空白やNULLのデータを後ろに

SELECT * FROM table_name ORDER BY
case
    when type is NULL then '2'
    when type = '' then '1'
    else '0'
end, type ASC;

SELECT * FROM wp_saiyou WHERE 1 ORDER BY case when baitai='' then '1' else '0' end, baitai