[weirfire]

One fantastic method for searching for keyterms I've found is

SELECT * FROM table WHERE fieldname LIKE '%keyword%'

This returns all the results from the table where the value in the field has the keyword somewhere in the text.