mysql use like with multiple values

[mister_v]

Hello,

I having a query that has to search multiple values:

Code: Select all

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

Code: Select all

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.

[chris]

You can use REGEXP.

Code: Select all

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

It should work.