今天 SELECT * FROM do_inspect_record WHERE date(created_at) = curdate() 昨天 SELECT * FROM do_inspect_record WHERE date(created_at) = curdate() - 1 大前天、前N天以此类推… 近30日 SELECT * FROM do_inspect_record WHERE DATE_SUB( CURDATE( ), INTERVAL 30 DAY ) <= created_at