Hello,
I'm trying to do a mysql select statement like this:
SELECT * FROM news WHERE newstype = '1' AND global = '1' OR depart =
'center' ORDER BY SortNumber ASC
But I would like the ORDER BY to list all records where depart = 'center'
first and then all the rest of the depart records in
alphabetical order.
Any ideas?
Larentium
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php