Jump to content

Archived

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

lawguru

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.

 

Bahman

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.