Jump to content


Photo

Simple query in mysql


  • Please log in to reply
2 replies to this topic

#1 lawguru

lawguru
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 12 February 2003 - 03:15 AM

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
Bahman

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 12 February 2003 - 06:53 AM

select count(body) as howmany from message where body like \'%phrase%\';
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 lawguru

lawguru
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 14 February 2003 - 10:51 AM

Thank you so much. Your suggestion worked great.
Bahman




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users