[Resolved] order by - but put zero at bottom

[cretaceous]

trivial question:

for a 'rank' column with possible values 0 to 5

I want to display rows in order: rank '1', '2', '3' etc and lastly any with value '0' - there can be multiple rows with '0' rank.
(Value zero is the default undefined value, integers are user assigned)

obviously ORDER BY 'rank' doesnt do it

I ended up getting php to force my zero values to equal 7 which works fine but is a kludge

is there a better way to use ORDER BY to solve the problem?

[AstroTeg]

You could kludge it in your SQL by using IF() and testing if its 0 and assigning it a larger number than 5.

[Lars_Berg]

order by  

case rank when 0 then 1 else 0 end,
rank

[cretaceous]

thanks Lars - didn't know mysql did case statements - cool

(that'll be very super cold in Uppsalla I expect!)