Re: Sorting by more than 1 column
> 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 acending and one descending. All info you need is here: http://www.mysql.com/doc/en/Sorting_rows.html Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sorting by more than 1 column
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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sorting by more than 1 column
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 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 acending and one descending. > > Thanks, > > Ed > > > > -- > 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]
Re: Sorting by more than 1 column
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 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 acending and one descending. > > Thanks, > > Ed > > > > -- > 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]
Sorting by more than 1 column
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 acending and one descending. Thanks, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]