Is it possible to combine LIKE / NOT LIKE and IN ?

[Varius]

Hi all,

I was just curious if it's possible to combine LIKE / NOT LIKE and IN with MySQL?

Say for example, I have the following query:

SELECT a FROM table WHERE a LIKE '%blah%' OR a LIKE '%wooo%' OR a LIKE '%hello%';

Is there anyway to have it be something like this instead?

SELECT a FROM table WHERE a LIKE IN ('%blah%','%wooo%','%hello%');

Seems to me that would be a much neater, shorter way of writing queries.

[dagon]

you could do that with a a Regular Expression