Webmaster2020.com

Posted: **Tue May 26, 2015 6:55 pm**

Hello,

I having a query that has to search multiple values:

SELECT id,name FROM table WHERE name LIKE '%value1%' OR name LIKE '%value2%' OR name LIKE '%value3%'

I'm wondering if there isn't a faster way?
Something like

SELECT id,name FROM table WHERE name LIKE IN ('%value1%','%value2%','%value%')

But this doesn't work, it only works if you search the full value, not part of string.

Posted: **Tue May 26, 2015 8:05 pm**

You can use REGEXP.

SELECT id,name FROM table WHERE name REGEXP 'value1 | value2 | value3'

It should work.

mysql use like with multiple values