How do I create a keyword search in MySQL?

You need to use something like:

LIKE '%$search%'

and there are many alternatives like using REGEXP for regular expression-based searching.

Note: LIKE is case insensitive.

---------------------------
Relevant links:

String Comparison Functions - explains the LIKE syntax.

MySQL Full-text Search - explains another possible approach using MATCH and AGAINST.

---------------------------
Relevant FAQs:

How do I do a search and replace on entries in my MySQL database?

________________________
Emperor

(Added by: Emperor on Mon 09-Dec-2002)

(Edited by: Emperor on Tue 08-Jul-2003)