SELECT
`id`,
`content`,
`created_at`
FROM
`messages`
查询一个月
WHERE DATE_SUB(CURDATE(), INTERVAL 1 month) <= date(created_at)
查询一周
WHERE DATE_SUB(CURDATE(), INTERVAL 7 day) <= date(created_at) 或者
WHERE datediff( curdate( ), created_at ) < 7