Using "AND", "OR",... in MySQL queries

[IWeb]

Hello,

I want to search in a text-field in a MySQL 3.23.x Database for certain strings.

The usere's input from the form can inlcude "AND" and "OR" and similar statements.
How can I do such searches with MySQL?

A sample user's search term could look like this:

Einstein AND Albert OR Max AND Planck

Terms withing ""s should be exactly searched for:

"Einstein Albert"

can you give me some hints please,

thanks

[Bunkermaster]

http://www.w3schools.com/sql/sql_and_or.asp

this tutorial is general SQL but always helps 🙂

[IWeb]

This is a bit general but I will take a look on it and perhaps I can find something I could use...