MySQL按中文排序

正序:

select t1.business_title,t1.create_at
from t_business_info t1
order by convert(t1.business_title using gbk) asc

  

倒序

select t1.business_title,t1.create_at
from t_business_info t1
order by convert(t1.business_title using gbk) desc

  

posted @ 2021-10-19 10:44  蛋挞小子  阅读(45)  评论(0编辑  收藏  举报