Need help with special (?) search engine!

[Anon]

First I want to apologize for my bad english.
I want to create a php mysql search engine. It will be a cocktailrecipe search engine. The user has to insert the ingredients and the search engine just picks out the cocktails which contain no more than the selected ingredients.
This means i have to compare the selection and the content of the table. i do know how to compare the content of a table with a variable but i do not know how to compare the variable with the content of a table.

Thanx for your support

Michael (Germany)

[Anon]

Check out the mysql docs at http://www.mysql.com/documentation/ but I believe you'd be looking along the lines of something like:

%SELECT * FROM table WHERE cocktails LIKE %$queryString %"

Not tested just thought on the spot. LIKE is the key thing you use for searching in SQL... might be something better... I'm not to educated when it comes to good sql.

Billy