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                 

  

posted @ 2018-08-10 17:35  宇枫  阅读(719)  评论(0编辑  收藏  举报