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 Quote 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%\'; Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/144-simple-query-in-mysql/#findComment-452 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.