Oracle, and ?(I've forgotten)? in mysql. "LIKE
'%#form.words#%'" queries are best avoided, for speed
and feature reasons. In general, text indexing allows
ranked searches, stemming, thesauri, and other nice
featuers.
--- Frank Dewey <[EMAIL PROTECTED]> wrote:
> 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]
