当前时间
to_day(now())
昨天
to_day(now()) - to_day(时间字段) = 1
前 n天
to_day(now()) - to_day(时间字段) = n
查询前n天数据
select..... where to_day(now() ) - to_day(时间字段) <= n
当前时间
to_day(now())
昨天
to_day(now()) - to_day(时间字段) = 1
前 n天
to_day(now()) - to_day(时间字段) = n
查询前n天数据
select..... where to_day(now() ) - to_day(时间字段) <= n