Hi,
I'd like to do a dual order by. First, I want to order by City, then I want to order name. That way, the names within the city are alphabetized.
I can easily do an order by City into a temp table, then order by name from within the temp table. Is this the best way? Is this the only way?
ORDER BY city, name
http://dev.mysql.com/doc/mysql/en/sorting-rows.html
I hope you're wearing a flame-retardant suit, because the flames are about to fly. :)
Regards,
Jeremy
-- Jeremy Cole Technical Yahoo - MySQL (Database) Geek
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]