mysql 时间查询

24小时内记录（即86400秒）

$sql="SELECT video_id,count(id)as n FROM `rec_down` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(add_time)<=86400 group by video_id order by n desc ";
$sql="select a.id,a.title,b.n from video_info a,(".$sql.")b where a.id=b.video_id order by n desc limit 20";

 

N天内记录

WHERE TO_DAYS(NOW()) - TO_DAYS(时间字段) <= N

今天的记录

where date(时间字段)=date(now())

或

where to_days(时间字段) = to_days(now());

 

查询一周：

select * from table   where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(column_time);

查询一个月：

select * from table where DATE_SUB(CURDATE(), INTERVAL INTERVAL 1 MONTH) <= date(column_time);