我个人觉得遇到这种模糊查询,like 关键字特别好用,下面是使用 like 关键字查询的题解:
SELECT DAY(date) day,
COUNT(question_id) question_cnt
FROM question_practice_detail
WHERE date like '%2021-08%'
GROUP BY day;