i have an question about ordering a set of records... a b c d --------------------------------------------- 1 Tax 1 2000 1.33 1 Tax 1 1500 2.5 1 Tax 1 1000 3.25 1 Tax 1 0 4.5
But I want the records to return as such: ascending by (c) with the zero being the last record: like below: 1 Tax 1 1000 3.25 1 Tax 1 1500 2.5 1 Tax 1 2000 1.33 1 Tax 1 0 4.5 any suggestions? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]