MySQL Forums
Forum List  »  Newbie

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'

Options: ReplyQuote

Written By
October 29, 2010 11:47PM
October 30, 2010 03:28AM
Re: Multiple LIKE values
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.