I'm looking into searching a website for a particular string or
occurence of a string. I would like for this to be an advanced search
(what I am looking for is something more complex than a simple LIKE).
In the database - QBOS_HELPFILE (id, name,keywords) - I am storing a
list of words separated only by spaces. And I am starting out with this
query:
SELECT *
FROM QBOS_HELPFILE
WHERE keywords LIKE '%#form.words#%'
I've tried separating the words by commas and using the IN operator, but
that only works if the field (keywords) contains one word
Maybe a combination of the In operator and LIKE depending on the search
text - if the search text has quotes or not. Of course the text should
be first parsed. I'm not sure what the best way to go about this is.
Are their some good examples out there? I've looked at Verity a
little...but I'm not sure that is what I need.
Are there any suggestions/help on this matter that ya'll can help me
with? Thank you -
Frank
-----------------------------------------------------------
The Preceeding Email Has Been Scanned
and Verified By QBOS Security Systems
-----------------------------------------------------------
QBOS, Inc.
14275 Midway Rd. Suite 220
Addison, TX 75001
972.233.5066
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
