SELECT * FROM banner
ORDER BY CASE when sort<>0 then sort else 99999 end asc;
SELECT * FROM banner
ORDER BY CASE when sort<>0 then sort else 99999 end desc;
SELECT * FROM banner
ORDER BY sort = 0,sort asc;
SELECT * FROM banner
ORDER BY sort = 0,sort desc;
上面两种方法都可以的