select * from pubs.dbo.titles where notes like'%aa%'
select * from titles where notes like '%aa%'
use pubs go select * from titles where titles like '%aa%'
use pubs go select * from titles where titles like '%aa%'
WOW,散分贴!地球人都用like,我来自火星,我不用like use pubs go select * from titles where charindex('aa',titles) <> 0 select * from titles where patindex('%aa%',titles) <> 0 select * from titles where len(replace(titles,'aa','')) < len(titles) select * from titles where (len(titles)-len(replace(titles,'aa','')))/len('aa') > 0 --这个可以查出来含有多少个aa
where notes like'%aa%'
go
select * from titles where titles like '%aa%'
go
select * from titles where titles like '%aa%'
use pubs
go
select * from titles where charindex('aa',titles) <> 0
select * from titles where patindex('%aa%',titles) <> 0
select * from titles where len(replace(titles,'aa','')) < len(titles)
select * from titles where
(len(titles)-len(replace(titles,'aa','')))/len('aa') > 0 --这个可以查出来含有多少个aa