CONVERT
ORDER BY CONVERT(表别名.字段名 USING gbk) COLLATE gbk_chinese_ci ASC;
birary
ORDER BY BIRARY(表别名.字段名) ASC;
直接排序
ORDER BY 表别名.字段名 ASC;
mysql实现按照汉字拼音排序
原文:https://www.cnblogs.com/dakuzai/p/14738124.html