[mysql] ORDER BY custom

[luca200]

select colonna, CASE colonna WHEN 'nuovo' THEN 1 WHEN 'cielo' THEN 2
 WHEN 'gatto' THEN 3 WHEN 'certo' THEN 4 ELSE 5 END as ordine
FROM......
WHERE.....
ORDER BY ordine

http://dev.mysql.com/doc/refman/5.0/...functions.html