Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Full Text Search Advice |
Wed, Oct 15 2008 4:05 PM | Permanent Link |
Scott Woods | I want to implement full text search for a general database application. I have a classis cusomer form (Last Name, Address, Phone, etc...) and I
want to make a single search edit box that will search for a field in the DB - Google like. What is the best approach? Should I copy and past the text from each individual fields (Last Name, Address,...) into a blod / clob field (SearchField) that can use FTS? |
Wed, Oct 15 2008 4:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Scott,
<< I want to implement full text search for a general database application. I have a classis cusomer form (Last Name, Address, Phone, etc...) and I want to make a single search edit box that will search for a field in the DB - Google like. What is the best approach? Should I copy and past the text from each individual fields (Last Name, Address,...) into a blod / clob field (SearchField) that can use FTS? >> No need. Just create a text index on each desired column, and then search on them all like this: SELECT * FROM MyTable WHERE "Last Name" CONTAINS 'Search Words' OR "Address" CONTAINS 'Search Words' OR .....etc. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |