Passing a column into CONTAINSTABLE/CONTAINS

• Romy The Cat

  SSC Journeyman

  Points: 87

  More actions

  December 18, 2021 at 2:52 am

  #3964977

  I am running a search, passing a column with keywords into inner joint.

  SELECT          SentimentCategoriesAncors._pk AncorID, Clip._pk ClipID
  FROM          SentimentCategoriesAncors INNER JOIN Clip ON Clip.title  LIKE '%' + SentimentCategoriesAncors.incude + '%'

  I need get some speed and put some fuzzy logic in play. So, I indexed Clip.title into Full-Text Search and trying to do something like this

  SELECT          SentimentCategoriesAncors._pk  AncorID, Clip._pk  ClipID
  FROM          SentimentCategoriesAncors, ClipWHERE  CONTAINS(title, SentimentCategoriesAncors.incude)

  … it does not take it and expects a hard string.  Did anybody was able to hack it or to encode the column name somehow. I do not want to go with dynamic SQL… Thanks.

• DesNorton

  SSC-Insane

  Points: 24386

  More actions

  December 18, 2021 at 8:22 am

  #3965039

  Using LIKE %SomeVal% is always going to be slow as SQL has to do a table/index scan.

  However, I have gotten pretty good performance using Trigram searches

  https://sqlperformance.com/2017/09/sql-performance/sql-server-trigram-wildcard-search

   

  ---

  How to post data/code on a forum to get the best help.