mysql中文排序

select name from test1 order by convert(name using gbk) asc;