MSFull-Text searching exactly text by CONTAINS

 
 
declare @SearchContent varchar(100) = '4 wheel drive'
declare @ModifiedSearchContent varchar(100) = '"'+ @SearchContent+'"'
 
 
select SearchContent, * from marsweb_CarIndex where CONTAINS (SearchContent, @ModifiedSearchContent)  AND SearchContent LIKE '%'+@SearchContent+'%'
 
 
declare @SearchContent varchar(100) = '4 wheel drive'
declare @ModifiedSearchContent varchar(100) = '"'+ @SearchContent+'"'
 
 
select SearchContent, * from marsweb_CarIndex where CONTAINS (SearchContent, @ModifiedSearchContent)  AND SearchContent LIKE '%'+@SearchContent+'%'
 

 

Etiquetas: