我有一个表 table1中的一个A1字段为
a1
1,2,3,4,5
2,3,4,5,6
5,7,8,9,0
11,34,234,52
3,6,8,9
然后我有一个字符3,那么我想查找A1字段包含3的字符的记录
要效率高一点的方法,不用CHARINDEX 和like 方法,
------解决方案--------------------
- SQL code
create table t1( a1 varchar(20))insert into t1select '1,2,3,4,5' union allselect '2,3,4,5,6' union allselect '5,7,8,9,0' union allselect '11,34,234,52' union allselect '3,6,8,9'select * from t1select * from t1 where LEN(a1)-len(REPLACE(a1,'3',''))>0
------解决方案--------------------
- SQL code
select * from t1 where LEN(a1)-len(REPLACE(a1,'3',''))>0