FreeText Query - Contains

• B T-460322

  Grasshopper

  Points: 15

  More actions

  October 1, 2014 at 8:36 am

  #293903

  Hello friends,

  I am looking to filter the query using the free text predicate Contains for one of the column that have dimensions of the items. The query is something like

  Select * from sampletable

  where contains(filtercolumn, 'Near("*cm , *cm , *cm , *Kg.",10,True)')

  Data in the filtercolumn is something like 64cm x 25cm x 35cm = 10Kg.

  The query do not return any data. Please advise.

  I also tried running the below query to see if cm* can be searcher for, but with no result again

  Select * from sampletable

  where contains(filtercolumn,, '"cm*"')

  If I do something like below, it does return all columns that have 35cm within the text.

  Select * from sampletable

  where contains(filtercolumn,, '"35cm"')

• Eirikur Eiriksson

  SSC Guru

  Points: 182882

  More actions

  October 4, 2014 at 3:37 pm

  #1750158

  Quick thought, full text search is not going to perform (or even work) when searching for a suffix, probably better off using the LIKE operator here.

  😎