[数据库] MYSQL之SQL查询(日期时间篇)

CASE:查询当天/昨天数据 # 当天 select * from table where to_days(时间字段) = to_days(now()); # 昨天 select * from table where to_days(now( ) ) - to_days( 时间字段名) <= 1 C