Jump to content


This topic is now archived and is closed to further replies.


Simple query in mysql

Recommended Posts

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.



Share this post

Link to post
Share on other sites

select count(body) as howmany from message where body like \'%phrase%\';

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.