Is there LIKE IN in mysql?

Answer 1

No.

But there is fulltext search. Maybe that goes into the right direction?

mysql> SELECT id, body   
    -> FROM articles WHERE MATCH (title,body) AGAINST
    -> ('Keyword1 Keyword2 Keyword3');

Answer 2

Per this prior stackoverflow question, you might have better luck with a REGEXP query:

http://stackoverflow.com/questions/1127088/mysql-like-in

Answer 3

No, but you may be able to use RLIKE depending on your version of MySQL

Answer 4

No, but you could use REGEXP.

...WHERE field REGEXP 'abc|xyz'