PHP search help

[chadconger]

Okay guys here is my problem. I have a table in my database called info. In this table there is a field named keywords. The keywords in this field are seperated by a comma and a space (example: 'dog, black, fuffy, cute'). I have a form on a page called seachform.php that posts the variable $keywords to a page named search.php. This is where I'm stuck. How do I search the database for key words? I'm not sure hoe to write the SQL query or how to handle the post if the user enters more than one word such as 'black dog'. Any help would be great! THANKS!

[FuZion]

I suppose you could use MySQL's FULLTEXT search. Google it, there's alot of tutorials.

[mylegoh]

I would suggest using regular expression in your mysql search command. There quite a few tutorials online. Try google-ing.