比如我有表A,有以下数据id aname
1 1,11,5,
2 2,23,4,5,11,
3 1,22,143,3,我想比如我传一个2就获得数据
id aname
2 2,23,4,5,传1就获得
id aname
1 1,11,5,
3 1,22,143,3,
怎么做呢?
1 1,11,5,
2 2,23,4,5,11,
3 1,22,143,3,我想比如我传一个2就获得数据
id aname
2 2,23,4,5,传1就获得
id aname
1 1,11,5,
3 1,22,143,3,
怎么做呢?
select * from tb where aname like '2,%'
from ta
where charidex(',2,',','+aname+',') > 0
select * from tb where aname like '1,%'
select * from tb where aname like '2,%'--包含某个数字
select * from tb where charindex(',1,', ','+aname+',')>0
set @I = 2
select *
from ta
where charidex(',+ltrim(@i)+,',','+aname+',') > 0
set @I = 2
select *
from ta
where charidex(','+ltrim(@i)+',','+aname+',') > 0
select * from table where charindex(cast(id as varchar)+',',anname)=0 or charindex(','+cast(id as varchar)+',',anname)>0
select * from table where charindex('1,',anname)=0 or charindex(',1,',anname)>0
select * from table where charindex('1,',anname)=1 or charindex(',1,',anname)>1