34,588
社区成员
发帖
与我相关
我的任务
分享
T1
Id Name
1 1,2,3
2 4,5,6
3 7,8,9,10,11
--用一条sql语句找出name字段包含5的记录,有点难度吧
Id Name
2 4,5,6
select * From tab where ','+name+',' like '%,5,%'
DECLARE @T1 TABLE([ID] INT,[NAME] VARCHAR(11))
INSERT @T1
SELECT 1,'1,2,3' UNION ALL
SELECT 2,'4,5,6' UNION ALL
SELECT 3,'7,8,9,10,11'
DECLARE @ID INT SET @ID=5
SELECT * FROM @T1 WHERE CHARINDEX(','+LTRIM(@ID)+',',','+NAME+',')>0
/*
ID NAME
----------- -----------
2 4,5,6
*/
select * from t1 where name like '%5%'