mysql date functions

[Anon]

Hi,
Would like to do a select using mysql date functions, not php's- select statement is going to be a join where the primary issue will be taking a date formated column and returning all records in which are less then 30 days from todays date..i assume its something, in pseudo:
select * from table where date < curdate() + 30? would someone elaborate a more elegant and correct way.

Thanks

[Anon]

something like this...

SELECT something FROM table
WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30

where date_col is the name of your date field