Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread full text search for complete phrase only
Wed, Jan 24 2007 12:50 PMPermanent Link

"Keith Crusius"
If I do a full text search on for example, "default order" then I get all
records that contain both words even when they're not together.  What's the
best way to get only the exact phrase "default order"?  TIA.

Wed, Jan 24 2007 1:12 PMPermanent Link

"Keith Crusius"
I got it done by adding the LIKE operator.  Is that the easiest?  "and
UPPER(colunm) LIKE '%DEFAULT ORDER%'"

Wed, Jan 24 2007 1:39 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Keith


TEXTSEARCH "simply" returns records that have all of the words in any order and with any separation. It doesn't search for phrases which is what you want, and, as you've found, is exactly what LIKE does.

Depending on the size of the database, and the size of the text fields you may find the response a bit slow. If so I'm not sure but combining TEXTSEARCH and LIKE may speed things up eg

TEXTSEARCH('default order' in column)  AND UPPER(colunm) LIKE '%DEFAULT ORDER%'"


Roy Lambert
Image