Re: how to search for a keyword within a text field?

Naveen Nalam wrote: > > hi, > > I have a text field which stores filenames. I want to create a query > which will look for a keyword within the filename. > > For example: if the filename is "mypoker.zip" and the user searches > for "poker", how can I get the result? I know I could use LIKE > "%keyword%", but is that efficient? I'm planning on having several > million entries. > > Another question: If the user types in say 3 keywords, how can I have > results ordered by (1) entries that contain all 3 keywords, (2) > entries that contain 2 of 3 keywords, and (3) entries that contain > only 1 of 3? > > thanks a bunch. :) > > -naveen Sounds like a job for IUS plus Excalibur text datablade to me. Alternatively, use a text database such as Lotus Notes, Stairs, Status, etc. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/