lawguru

Thank you so much. Your suggestion worked great.

Hello - I am trying to run a simple query in mySQL (actually we use phpMyAdmin) that allows me to pull/display the number of records in a table that contain a certain word or phrase in one of the table\'s field. For example I am trying to see how many times the phrase \"power of attorney\" or \"bill of sale\" or \"lease\" appear in a field called \"body\" in the table called \"message\". I assume this could be done with a SELECT ... WHERE query but I can\'t seem to be able to figure it out. Could anyone please tell me what the query would look like? I would really appreciate any help anyone cane give. Thanks. Bahman