MySQL中的今天、昨天、近30日

今天

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