mysql按中文拼音排序

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