Select records from NOW() -1 Day
Judging by the documentation for date/time functions, you should be able to do something like: SELECT * FROM FOO WHERE MY_DATE_FIELD >= NOW() – INTERVAL 1 DAY
Judging by the documentation for date/time functions, you should be able to do something like: SELECT * FROM FOO WHERE MY_DATE_FIELD >= NOW() – INTERVAL 1 DAY