mysql 根据字母排序

select CONVERT(u.user_name USING gbk) AS user_name

from table where 1=1 order by user_name