[PHP] mySQL Query - comparing multiple values with one field

[Niklas Lampén]

What I need to do is to compare if one field matches a value from a huge
list of values.

Do I need to query like
"SELECT * FROM table WHERE field LIKE '%value1%' || field LIKE '%value2%'"
or can I do it something like this
"SELECT * FROM table WHERE field LIKE ('%value1%' || '%value2%')"?


Niklas Lampén