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
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?
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