mysql get 4 day interval or of record code example Example: mysql interval 1 day SELECT * FROM FOO WHERE MY_DATE_FIELD >= NOW() - INTERVAL 1 DAY