MySQL问题

SQL语句根据拼音首字母排序


SELECT ship_num
FROM xcb_ship_ll_newest
ORDER BY CONVERT( ship_num USING gbk ) COLLATE gbk_chinese_ci ASC;