Login ProductsSalesSupportDownloadsAbout |
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 |
"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 PM | Permanent 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 PM | Permanent Link |
Roy Lambert NLH Associates 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 |
This web page was last updated on Tuesday, April 23, 2024 at 08:10 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |