34,838
社区成员




create table tb(id int,value varchar(20))
insert into tb values(1,'1,3,5,6')
insert into tb values(2,'2,5,9')
select * from tb where charindex('3',value)>0 and charindex('6',value)>0
drop table tb
/*
id value
----------- --------------------
1 1,3,5,6
(所影响的行数为 1 行)
*/