Gossamer Forum
Home : Products : DBMan : Discussions :

Searching over multiple words

Quote Reply
Searching over multiple words
Maybe I'm missing something... say I have a database with 3 fields - name, date, and message.

If I put "and or the" in the "message" field for the search, it turns up nothing, even though I have many records in which the "message" contains all three of those words.

If I have a message that has the exact string "and or the" then it WILL match...

Do I need to do a regexp search, or is there a mod for this?

Thanks,

-Eric

Quote Reply
Re: Searching over multiple words In reply to
To search on multiple words, separate each word with a pipe, and tick the "regular expression" box.

eg: and|or|the

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Quote Reply
Re: Searching over multiple words In reply to
Thanks!

What if I want an "and" rather than an "or?"