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                 

  

原文地址:https://www.cnblogs.com/zyf-yxm/p/9456460.html