|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread|
|Messages 1 to 3 of 3 total|
|full text search for complete phrase only|
|Wed, Jan 24 2007 12:50 PM||Permanent Link|
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 PM||Permanent Link|
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 PM||Permanent Link|
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%'"