select from tb where charindex(','+接收人id+',',',1,2,3,4,5,6,12,13,14,')>0
DECLARE @T1 TABLE(id int,name nvarchar(10)) insert @T1 SELECT 1,'一' UNION ALL SELECT 2,'二' UNION ALL SELECT 3,'三' UNION ALL SELECT 4,'四' UNION ALL SELECT 11,'三' UNION ALL SELECT 12,'四' UNION ALL SELECT 13,'五'select * from @T1 where charindex(','+ltrim(id)+',',',1,2,12,13,')>0 id name ----------- ---------- 1 一 2 二 12 四 13 五(4 行受影响)
DECLARE @T1 TABLE(id int,name nvarchar(10))
insert @T1
SELECT 1,'一' UNION ALL
SELECT 2,'二' UNION ALL
SELECT 3,'三' UNION ALL
SELECT 4,'四' UNION ALL
SELECT 11,'三' UNION ALL
SELECT 12,'四' UNION ALL
SELECT 13,'五'select * from @T1 where charindex(','+ltrim(id)+',',',1,2,12,13,')>0 id name
----------- ----------
1 一
2 二
12 四
13 五(4 行受影响)