前端传来了一个月份,例如:2020-08,我现在想通过这个月份来查看这个月的记录里面有多少日是不重复的
SELECT DISTINCT date_format(ctime,'%Y-%m-%d') AS 'ctime' FROM notify
WHERE uid=0 AND (ctime>='2020-08-01 00:00:00' and ctime<='2020-08-31 23:59:59') order by ctime desc
结果:
总结:DISTINCT date_format(ctime,’%Y-%m-%d’)是关键