MySQL: Select records from today, this week and this month

by PHPMySQLTalk | Jan 16, 2015 | MySQL, PHP, Uncategorized | 0 comments

Assuming your date column is an actual MySQL date column:

SELECT * FROM jokes WHERE date > DATE_SUB(NOW(), INTERVAL 1 DAY) ORDER BY score DESC;        
SELECT * FROM jokes WHERE date > DATE_SUB(NOW(), INTERVAL 1 WEEK) ORDER BY score DESC;
SELECT * FROM jokes WHERE date > DATE_SUB(NOW(), INTERVAL 1 MONTH) ORDER BY score DESC;

Source: http://stackoverflow.com/a/5293226/1794834