按中文首个拼音字母排序的sql语句如何写

如果数据表tbl的某字段name的字符编码是latin1_swedish_ci;

select * from `tbl` order by birary(name) asc

如果数据表tbl的某字段name的字符编码是utf8_general_ci;

SELECT name FROM `tbl` WHERE 1

ORDER BY CONVERT( name USING gbk ) COLLATE gbk_chinese_ci ASC