SELECT blockid, blockname
FROM masterdb.mstblock
order by blockid
结果如下:
"blockid" "blockname"
0 ""
1 "九州"
2 "関西"
3 "東日本"
4 "中国"
9 "TW関東"
10 "TW九州"
11 "TW関西"
如果让block是9的排在最上面
SELECT blockid, blockname
FROM masterdb.mstblock
order by blockid=9 desc
结果如下:
"blockid" "blockname"
9 "TW関東"
10 "TW九州"
2 "関西"
11 "TW関西"
3 "東日本"
1 "九州"
0 ""
4 "中国"