经常会遇到排序问题,如用某些城市排前面等
SELECT `truename` , `truename`
REGEXP '.*王.*' AS a
FROM `keke_witkey_auth_law`
ORDER BY a DESC
用字符串的某一个字符排序
用某个区间排序
SELECT work_year, work_year
BETWEEN 1010851200
AND 1410851200 AS a
FROM `keke_witkey_auth_law`
order by a desc
show processlist 命令 查看慢查询