SELECT records published in last 5 days?

[invision2]

Hi,

I have a column in a table that stores the date (say, 2009-08-31 11:08:19).

Now, I'd like to do a SQL Query which would throw up TRUE if that date is either equal to, or in the past 5 days.

Does this make sense?

so if I had

id | name | date_added
1 | jake | 2009-08-31 11:08:19

and if today was 2009-09-02 then it would give me a result.


I did have something like this, but it didn't work

SELECT DISTINCT name FROM groups WHERE date_added >= (NOW()-7) 

Any ideas where to start?

[r937]

WHERE date_added >= CURRENT_DATE - INTERVAL 5 DAY

[invision2]

Brilliant!!!!

Many, many thanks sir. How easy was that, when you know how