lawguru Posted February 12, 2003 Share Posted February 12, 2003 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 Link to comment https://forums.phpfreaks.com/topic/144-simple-query-in-mysql/ Share on other sites More sharing options...
effigy Posted February 12, 2003 Share Posted February 12, 2003 select count(body) as howmany from message where body like \'%phrase%\'; Link to comment https://forums.phpfreaks.com/topic/144-simple-query-in-mysql/#findComment-426 Share on other sites More sharing options...
lawguru Posted February 14, 2003 Author Share Posted February 14, 2003 Thank you so much. Your suggestion worked great. Link to comment https://forums.phpfreaks.com/topic/144-simple-query-in-mysql/#findComment-452 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.