Mysql拼音排序
如果是gbk(汉字编码字符集),直接在查询语句后面添加order by
SELECT *
FROM runoob_tbl
ORDER BY xxx;
如果字符集采用的是 utf8(万国码),需要先对字段进行转码然后排序
SELECT *
FROM runoob_tbl
ORDER BY CONVERT(xxx using gbk);
原文地址:
https://www.runoob.com/note/27627
Mysql拼音排序
如果是gbk(汉字编码字符集),直接在查询语句后面添加order by
SELECT *
FROM runoob_tbl
ORDER BY xxx;
如果字符集采用的是 utf8(万国码),需要先对字段进行转码然后排序
SELECT *
FROM runoob_tbl
ORDER BY CONVERT(xxx using gbk);
原文地址:
https://www.runoob.com/note/27627