MySQL: Is there a clean way to do lots of AND/OR in a query?

BrianK · 08-03-2007, 11:57 AM

I need to do a query something like:

select * from foo where bar not like "LA%" AND bar not like "ML%" AND bar not like "FA%" etc. etc.

There's 10 things I need to compare and that list may grow. Is there a cleaner way to do this? I saw a couple examples while googling around, but my need to look for non-matches seems to not work with those examples.

Guttorm · 08-03-2007, 12:16 PM

Hi

Maybe this:

SELECT * FROM foo WHERE NOT (LEFT(bar,2) IN ('LA','ML','FA'));

However this will be case sensitive, whereas the LIKE will be case-insensitive. I don't know if this will be a problem.

BrianK · 08-03-2007, 12:32 PM

Quote:

Originally Posted by Guttorm

Hi

Maybe this:

SELECT * FROM foo WHERE NOT (LEFT(bar,2) IN ('LA','ML','FA'));

However this will be case sensitive, whereas the LIKE will be case-insensitive. I don't know if this will be a problem.

Perfect! Case sensitivity is not an issue in this case.

Thanks for the help!