all records less than 7 days old mysql

[topr8]

with sql server this is simple enough (to me)

but with mysql it seems to be harder
i have a column that records the date/time of the insert in the format

clickdate: 2006-03-01 15:03:59

i'm trying to retrieve records only inserted in the last week

SELECT yadda WHERE clickdate>=(CURRENT_DATE()-7)

this doesn't do it,
how do i? gnash gnash

[FalseDawn]

[dev.mysql.com...]

First example on the page.

[topr8]

great thanks,

i got to using date_add and trying to add a negative number of days.

date_sub did it