codice:
select *,if(campo = 'da decidere',1,if(campo is null or campo = '',2,3)) as ordine 
from tabella order by ordine,cast(campo as unsigned) desc