select * from topic
where DATE_SUB(CURDATE(),INTERVAL 3 DAY) <= time; http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
where DATE_SUB(CURDATE(),INTERVAL 3 DAY) <= time; http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
interval 是表示时间段,
3 day就是3天
date_sub就是 减法select * from topic
where DATE_SUB(CURDATE(),INTERVAL 3 DAY) <= time;
#取出三天内所有数据
select * from table where time>=time()-3*24*60*60