look into CONTEXT indexes. I'm not sure offhand if they'll do what you want
them to, but they are useful for indexing long text fields.
Other than that your only choice is to use multiple comparisons.
SELECT *
FROM QBOS_HELPFILE
WHERE keywords LIKE '%#word1#%' OR keywords LIKE '%#word2#%'... etc...
+-----------------------------------------------+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Frank Dewey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 16, 2004 1:59 PM
To: CF-Talk
Subject: advanced search
Hello all,
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]
