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
原文：https://www.cnblogs.com/zyf-yxm/p/9456460.html