SELECT * FROM mytable WHERE mydate > DATE_SUB(now(),INTERVAL 7 DAYS)