SELECT DISTINCT
substring_index(request_url, '/', 4) as substring_request_url, COUNT(request_url) as times
FROM
easy_log
WHERE left(request_url, 5) = '/api/'
GROUP BY
substring_request_url
ORDER BY
times DESC
mysql截取字符
最新推荐文章于 2021-02-18 20:52:26 发布