Untuk melakukan pencarian like yang multi umumnya seperti ini:
SELECT * FROM `jobposition` where name like ‘%supervisor%’ or name like ‘%manager%’ or name like ‘%director%’ or name like ‘%partner%’
Ternyata bisa disimple kan dengan :
SELECT * FROM `jobposition` where name REGEXP ‘supervisor|manager|director||partner’
Referensi:
https://stackoverflow.com/questions/4172195/mysql-like-multiple-values
https://forums.mysql.com/read.php?10,392332,392950#msg-392950
Mahrizal 