SELECT *, IFNULL(campo,3,IF(campo='',2,1)) as ordine FROM TABELLA ORDER BY ordine, campo