代码改变世界

mysql中find_in_set和SQL Server中charindex的区别

2018-07-27 14:56  马尔代夫_珍  阅读(1646)  评论(0)  编辑  收藏  举报

select charindex('test','this Test is Test')

 (select charindex('" + WUser_Id + "',PartId))>0 

 charindex(','+cast(b.JobType_Id as nvarchar(50))+',',','+isnull(a.JobType_Id,'0')+',')>0

 select * from WeChat_Task where charindex(',56,',','+WeChat_Task.PartId+',')>0

 

https://www.cnblogs.com/qianxingdewoniu/p/6858580.html