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