MySQL: Select today, yesterday or day before yesterday records

Usually when you work with records where a date or time-stamp field is present you need to select records from:

Lets say you have a table (my_table) like this:

Today records:

SELECT *
FROM `my_table`
WHERE `Date` = CURDATE()

Yesterday records:

SELECT *
FROM `my_table`
WHERE `Date` &gt; DATE_ADD(CURDATE(), INTERVAL -2 DAY) AND
	  `Date` &lt; CURDATE()

Day before yesterday records:

SELECT *
FROM `my_table`
WHERE `Date` &gt; DATE_ADD(CURDATE(), INTERVAL -3 DAY) AND
	  `Date` &lt; DATE_ADD(CURDATE(), INTERVAL -2 DAY)

If your `Date` field is a time-stamp or datetime then replace `Date` with date(`Date`)