[thelist] MySQL query: not like a, b, c,...
Tab Alleman
Tab.Alleman at MetroGuide.com
Fri Apr 9 08:15:54 CDT 2004
> And this seems to be another logic, it gives no results (no error
> either): $query = "select * from otn_user where
> ! user like 'a%' and
> ! user like 'b%' and...
My proposed solution was going to be along these lines, but I would have
written out NOT, and used parens:
WHERE
NOT (user LIKE 'a%') AND
NOT (user LIKE 'b%') AND...
Don't have MySQL to test it with though.
More information about the thelist
mailing list