判断某几列里是否存在某个字符串，语句要如何写呢？

[angleoldhen]

页面已经获取session["username"]，现在要找出数据表里某3列字段包含该用户名的记录，如何写呢？

比如：
字段名：id agroup bgroup cgroup

记录： 1 a,b c b,d
2 a b c

假设 session["username"]=d,那么我想取到第一条记录要怎么写呢？

[dawugui]

select top 1 * from tb where charindex(','+@session+',' , ','+agroup+',') > 0 or
                             charindex(','+@session+',' , ','+bgroup+',') > 0 or
                             charindex(','+@session+',' , ','+cgroup+',') > 0 

[-狙击手-]

select top 1 *
from table
where charindex(',d,',','+agroup+',') > 0 or charindex(',d,',','+bgroup+',') > 0
or charindex(',d,',','+cgroup+',') > 0
order by id

[dawugui]

--其中一个包含.
select top 1 * from tb where charindex(','+@session+',' , ','+agroup+',') > 0 or
                             charindex(','+@session+',' , ','+bgroup+',') > 0 or
                             charindex(','+@session+',' , ','+cgroup+',') > 0 
--三个都包含
select top 1 * from tb where charindex(','+@session+',' , ','+agroup+',') > 0 and
                             charindex(','+@session+',' , ','+bgroup+',') > 0 and
                             charindex(','+@session+',' , ','+cgroup+',') > 0 

[-狙击手-]

select top 1 *
from table
where charindex(',d,',','+agroup+','+bgroup+','+cgroup + ',') > 0
order by id

[smapple]

以上均正解。我就不写啦。：）

[nolast02]

正解
路过

[andy84]

不错
受益

[angleoldhen]

4楼的写法通不过啊

[andy84]

+@session
因为四楼的写法是变量赋值的
你前面加个
set @session=''d''

[andy84]

set @session='d'

[-狙击手-]

这样通用吗？

declare @name varchar(100)
set @name = 'd'
select top 1 *
from table
where charindex(',+@name+,',','+agroup+','+bgroup+','+cgroup + ',') > 0
order by id

[-狙击手-]

declare @name varchar(100)
set @name = 'd'
select top 1 *
from table
where charindex(','+@name+',',','+agroup+','+bgroup+','+cgroup + ',') > 0
order by id