SELECT * FROM FOO WHERE MY_DATE_FIELD >= NOW() - INTERVAL 1 DAY
...WHERE DATE_FIELD >= DATE_SUB(NOW(), INTERVAL 1 DAY)