Selecting based on a date range
mysql> SELECT something FROM tbl_name WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html »
[Click to add or edit comments])
Please prepend comments below including a date