SELECT * FROM table WHERE date = 'today'; 
SELECT * FROM table WHERE date >= '08-01-2006' # 7 days ago
SELECT * FROM table WHERE date >= '08-08-2005' # 12 months ago