> I didn't know if this was possible and haven't tried yet. My boss wants
> me to sort results by 3 columns (city, county, price.) He would like city
> and county in alphabetical order a-z and have price from highest to
> lowest. I told him I didn't think it was possible to sort two different
> fi
Hi,
> I told him I didn't think it was possible to sort two
> different fields one acending and one descending.
But, of course, it is possible :)
http://www.mysql.com/doc/en/SELECT.html
SELECT
...
ORDER BY
city, county, price DESC
Take care,
Aleksandar
--
MySQL General Mailing
ORDER BY city, price DESC
- Original Message -
From: "Ed Curtis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 2:00 PM
Subject: Sorting by more than 1 column
>
> I didn't know if this was possible and haven't tried y
ORDER BY city, price DESC
- Original Message -
From: "Ed Curtis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 19, 2004 2:00 PM
Subject: Sorting by more than 1 column
>
> I didn't know if this was possible and haven't tried y
I didn't know if this was possible and haven't tried yet. My boss wants
me to sort results by 3 columns (city, county, price.) He would like city
and county in alphabetical order a-z and have price from highest to
lowest. I told him I didn't think it was possible to sort two different
fields one
