Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Fulltext for multiple word Expand / Collapse
Author
Message
Posted Thursday, April 4, 2013 6:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, October 7, 2013 12:14 AM
Points: 14, Visits: 81
Hi,

I want to replace below query using fulltext Contain

select * from tx_Main_Data MD
where Column1 like '%This is for testing purpose%'


But using full text search I am getting some extra rows which do not contain the text.
Post #1438756
Posted Thursday, April 4, 2013 6:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 12, 2014 8:53 AM
Points: 6,917, Visits: 6,978
SELECT * 
FROM tx_Main_Data
WHERE CONTAINS(Column1,'"This is for testing purpose"')




Far away is close at hand in the images of elsewhere.

Anon.

Post #1438764
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse