select * from 表 where (day-3) >0 order by * DESC
或者
select 字段 from 表 where (DAY-10800) > 0 order by * DESC limit 0, 30;
unix时间戳-3天的second
或者
select 字段 from 表 where (DAY-10800) > 0 order by * DESC limit 0, 30;
unix时间戳-3天的second
SELECT * FROM TBL WHERE TO_DAYS(now())-TO_DAYS(datefield)<3;