select a date....

[Anonymous]

Hi
i'd like to delete all the data in a table which are stored since more dan one month....

DELETE FROM table WHERE datefiled > NOW()+ one month.....

is it possible to do like dat.....

how do i had a month to NOW().....
i use a Mysql database...

thanks for ur help

bye