Fulltext for multiple word

• pranav.thakur

  Old Hand

  Points: 398

  More actions

  April 4, 2013 at 6:42 am

  #276086

  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.

• David Burrows

  SSC Guru

  Points: 65138

  More actions

  April 4, 2013 at 6:57 am

  #1603523

  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.