mysql排序解决方案和查询SQL慢记录
经常会遇到排序问题,如用某些城市排前面等
SELECT `truename` , `truename`
REGEXP '.*王.*' AS a
FROM `keke_witkey_auth_law`
ORDER BY a DESC
用字符串的某一个字符排序
用某个区间排序
SELECT work_year, work_year
BETWEEN 1010851200
AND 141085
原创
2016-06-30 13:20:50 ·
2317 阅读 ·
0 评论