Well, I think I'll just stick with the story that I wuz jes' tryin' to
keep everbody on their toes....
It's the only way out I can see.
Thank-you.
:)
Jeremy Cole wrote:
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
