mysql排序解决方案和查询ＳＱＬ慢记录

经常会遇到排序问题，如用某些城市排前面等

SELECT `truename` , `truename`REGEXP '.*王.*' AS aFROM `keke_witkey_auth_law`ORDER BY a DESC

用字符串的某一个字符排序

用某个区间排序

SELECT work_year, work_yearBETWEEN 1010851200AND 1410851200 AS aFROM `keke_witkey_auth_law`order by a desc

show processlist 命令　查看慢查询