In article <[EMAIL PROTECTED]>, dan orlic <[EMAIL PROTECTED]> writes:
> 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? ORDER BY c = 0, c -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
