纯中文
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可可 |
暂时遇到这两种情况
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可可 |
暂时遇到这两种情况