7 messages in com.mysql.lists.mysqlSorting by more than 1 column
FromSent OnAttachments
Ed Curtis19 Jan 2004 05:00 
Hontvari Jozsef19 Jan 2004 05:11 
Hontvari Jozsef19 Jan 2004 05:12 
Aleksandar Bradaric19 Jan 2004 05:16 
Jigal van Hemert19 Jan 2004 05:18 
Mike Blezien19 Jan 2004 07:20 
Eve Atley19 Jan 2004 10:04 
Subject:Sorting by more than 1 column
From:Ed Curtis (ed@homes2see.com)
Date:01/19/2004 05:00:23 AM
List:com.mysql.lists.mysql

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