Berikut cara mencari like seperti In
SELECT * FROM tabel WHERE field REGEXP 'kriteria1|kriteria2|....|....'