CONTAINS function... how to implement like '%local wine%' in CONTAINS (*, ' "*local wine*" ' )

• ghitpro

  Old Hand

  Points: 308

  More actions

  February 22, 2014 at 8:41 am

  #288491

  Team,

  i implemented free text on several columns of a table and searching data with CONTAINS FUNCTION, table contains half million records. im using CONTAINS (*, ' "local wine*" ' ) However, is their any way to include "*local wine*" as we used in like clause '%local wine%'.

  Below LIKE clause works fine but takes long time because of half million records and i have to do for each column

  SELECT count(*) FROM DataDictionary WHERE column like '%local wine%'

  Below CONTAINS function work super fast but im not getting desire result

  SELECT count(*) FROM DataDictionary WHERE CONTAINS (*, ' "local wine*" ' )

  my goals is to count number of matches in several columns of a table for any given text like '%local wine%'

  thank you 🙂

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  February 22, 2014 at 5:23 pm

  #1691351

  Hm, interesting.

  Did you fulfill the full-text index?

  The columns should have the same "Language for Word Breaker".

  Igor Micev,My blog: www.igormicev.com