MySQL 排序

将查询结果按照个数和首字母排序(包含中文)

SELECT count(1) as num, name FROM user_page_tag  GROUP BY tag_name ORDER BY num desc, CONVERT(name USING gbk);