select t.*
from (select left(quarter, 4) as year, SUBSTRING(quarter, 7, 1) as num, a.*
from user_ecology_technology_policy_manage a) t
order by t.year desc, FIELD(t.num, '四', '三', '二', '一')
;
MySql 数字+汉字 排序
于 2022-09-03 11:01:13 首次发布