＋设为首页 ＋添加到收藏夹
假设表 Table1中有字段code,comlist
现有记录如下：
code comlist
01 101,102,103
02 101,103
请问如何用一条Sql语句找出字段comlist中包含‘103’的记录 ？
例如： select * from table1 where 103 in comlist ???
select * from table1 where comlist like "%103%"
select * from table1 where ,+comlist+, like "%,103,%"
select * from table1 where comlist like %103%
select * from Table1 where charindex(103,comlist)>0
