MySQL and multiple likes

[filburt1]

Originally Posted by Dean C

Not sure entirely what you're trying to do but have you looked into mysql's regexp capabilities - that may do it for you

I'm trying to compare a single column to an array of values with a single query. That is, let's say MySQL is looking at the column "alias" with the value "nobody". I want it to check against "noreply", "webmaster", "administrator", and "nobody", and if any of those are found as a substring within the alias, it will skip the row.

A regex will work but checking against an array is still the issue.