Select from Table where Age is one week

[Geronantimo]

I think the Subject line is slightly cryptic...

I have a simple query that outputs the records from a table that have dates 'entered' after 2008-04-01:

SELECT * FROM table_user w
WHERE w.`entered` >= '2008-04-01';

I am a complete novice trying to learn to perform some queries on my database and I would like to change the above query so that it returns all of the records that are one week old.

Is this possible and if so, could somebody please show me how?

Thanks

 

[Geronantimo]

Hi again,

I have changed the query to this:

SELECT * FROM table_user w
WHERE w.`entered` >= NOW() - INTERVAL 7 DAY;

Is this good or bad "MySQL"?

 

[TonyGroves]

Looks fine.