php - 如何编辑我的查询以显示每天的输出？

Question

我如何编辑以下查询以返回而不是返回 5 行

date --- rows found
date --- rows found
date --- rows found

这里是查询

SElECT * FROM emails WHERE maildate >= DATE_ADD(CURDATE(), INTERVAL -3 DAY) and company_id = 1 order by maildate desc

Answer 1

在 maildate 和 COUNT(*) 上分组应该有效:

SELECT maildate, COUNT(*) as TotalEmails --change alias as desired
FROM emails
WHERE maildate >= DATE_ADD(CURDATE(), INTERVAL -3 DAY) 
AND company_id = 1 
GROUP BY date(maildate) --Remove timestamp for grouping
ORDER BY maildate desc

虽然不清楚你想要返回什么。示例数据和预期输出会有所帮助。