select * from table where charindex(关键字,username)>0
1 select * from tb where username like '%关键字%' 2 select * from tb where charindex(关键字,username)>0
--1 select * from tb where username like '%关键字%' --2 select * from tb where charindex('关键字',username)>0 --3 select * from tb where PATINDEX('%关键字%',username)>0
select * from table where charindex(关键字,username)>0
1 select * from tb where username like '%关键字%'
2 select * from tb where charindex(关键字,username)>0
select * from tb where username like '%关键字%'
--2
select * from tb where charindex('关键字',username)>0
--3
select * from tb where PATINDEX('%关键字%',username)>0