mysql按中文拼音排序

  1. 正序:
    1
    select * from table_name ORDER BY CONVERT(name USING gbk);
  2. 倒序:
    1
    select * from table_name ORDER BY CONVERT(name USING gb2312) desc