这样的查询，不知道是否可以

[caiyi000]

比如我有表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,


怎么做呢？

[dobear_0922]

select * from tb where aname like '1,%'
select * from tb where aname like '2,%'

[kakajya]

select * from A where aname like '要传的参数%'

[-狙击手-]

select *
from ta
where charidex(',2,',','+aname+',') > 0 

[liangCK]

select * from tb where charindex(',1,',@aname)>0

[kakajya]

你的aname是varchar()类型吧..

[wangchangk]

charindex

[dobear_0922]

--以某个数字开头
select * from tb where aname like '1,%'
select * from tb where aname like '2,%'

--包含某个数字
select * from tb where charindex(',1,', ','+aname+',')>0

[-狙击手-]

declare @i int
set @I = 2
select *
from ta
where charidex(',+ltrim(@i)+,',','+aname+',') > 0 

[-狙击手-]

declare @i int
set @I = 2
select *
from ta
where charidex(','+ltrim(@i)+',','+aname+',') > 0 

[wpeng8218]

米看懂，你传入的对记录的影响规则是怎么样的！

[caorobby]

条件查询里面 charindex 匹配类似
select * from table where charindex(cast(id as varchar)+',',anname)=0 or charindex(','+cast(id as varchar)+',',anname)>0

[caorobby]

or
select * from table where charindex('1,',anname)=0 or charindex(',1,',anname)>0

[caorobby]

or
select * from table where charindex('1,',anname)=1 or charindex(',1,',anname)>1

[caorobby]

索引从1开始