search form with "or" input search posibility?

[erxefera]

HI!

I'm trying to figure out, how to make seach form with one text field, that will accept OR statements. I have one table with fields name, category, and description.
Is there any chance to make search like this:
User will put "part of the string" OR "part of the string2".
Result will be the list of the records that include these parts of the strings in any of the given above fields (name,category,description)
I hope i'm clear enough

Thank You in Advance
for any Advice

 

[ColinEssex]

Have you checked out the search databases in the database samples forum?

Col

 

[erxefera]

Thank's for that example but i can't see here any possibility for

Name= Smith Or Parker....search