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]