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

Mike evolt at muinar.com
Thu Apr 8 14:10:25 CDT 2004


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 s. krischker  http://webdesign-schweiz.ch/
        flashpro mailing list  http://flash-list.com/
        royalty free flash sounds  http://flash-sounds.com/

More information about the thelist mailing list