两个方法:
1.模糊查询like
select * from tablename where field1 like like ‘%key%’
2.用charindex()
charindex(字符,字符串)>0 为包含
1.模糊查询like
select * from tablename where field1 like like ‘%key%’
2.用charindex()
charindex(字符,字符串)>0 为包含