SELECT *
FROM table
WHERE date BETWEEN 2013-05-03 AND 2013-05-04;