mysql中文排序问题

纯中文

select * from user order by convert(column USING gbk/gb2312);

数字+中文

order by column+0 desc/asc或order by column*1 desc/asc

name 30小明 20可可 40莫干娜

排序:

select name from user order by name+0 desc

结果:

name 40莫干娜 30小明 20可可

---

暂时遇到这两种情况