select * from table1 where fields like '%姚%' and fields like '%超%'
select * from table1 where fields like '%[姚超]%'
select * from a where CHARINDEX('姚',a)>0 or CHARINDEX('超',a)>0
select * from a where CHARINDEX('姚',a)>0 or CHARINDEX('超',a)>0
up select * from table1 where CHARINDEX('姚',fields )>0 or CHARINDEX('超',fields )>0 或 select * from table1 where PATINDEX('%姚%',fields )>0 or PATINDEX('%超%',fields )>0
select * from table1 where CHARINDEX('姚',fields )>0 or CHARINDEX('超',fields )>0
或
select * from table1 where PATINDEX('%姚%',fields )>0 or PATINDEX('%超%',fields )>0