MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Multiple LIKE values
Posted by: Rick James
Date: November 03, 2010 04:35PM

WHERE x LIKE '%knife%' OR x LIKE '%spoon%';

Simpler, and probably faster:
WHERE x REGEXP 'knife|spoon'

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Multiple LIKE values
Mike Miller
October 29, 2010 11:47PM
Re: Multiple LIKE values
laptop alias
October 30, 2010 03:28AM
Re: Multiple LIKE values
Rick James
November 03, 2010 04:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.