[thelist] MySQL query: not like a, b, c,...

[Joshua Olson]

> -----Original Message-----
> From: Mike
> Sent: Thursday, April 08, 2004 3:10 PM

> How could a MySQL query look like, that selects all users that don't
> start with a, b, c... z?
>
> $query = "select * from otn_user where
> user ! like 'a%'
> user ! like 'b%' and
> user ! like 'c%' and
> .
> .
> .
> user ! like 'z%'
> order by user";
>
> ... throws an error :-/

Mike,

Not an MySQL guru, but (without the specific error text this is tough)
perhaps the logical operator is out of order?

user NOT LIKE 'z%'
! user LIKE 'z%'

??

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168