Does order by City,name help? ----- Original Message ----- From: "Robert Pruitt" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Thursday, February 10, 2005 10:11 AM Subject: Compound Order By
> 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? > > Just wonderin' > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]