27,579
社区成员
发帖
与我相关
我的任务
分享
select * from tb WHERE patindex('%,1,%' ,','+indexs+',')>0 --多一个e,改一下。
select * from tb WHERE patindex('%,1,%' ,','+indexes+',')>0
select * from tb where charindex(',1,',','+indexs+',')>0
select * from tb WHERE CHARINDEX(',1,',','+indexes+',')>0
select .... where charindex(',1,',','+indexs+',')>0
WHERE CHARINDEX(',1,',','+indexes+',')>0