mysql排序的中文首字母排序和自定义排序
select
*
FROM organ_new
where city_code = 'SZ0755' and organ_type =
'H' and state = '1'
ORDER BY
FIELD(organ_category,'三级','二级','一级') ,#自定义排序
CONVERT(organ_name USING gbk) COLLATE #中文首字母排序
gbk_chinese_ci DESC

浙公网安备 33010602011771号