[thelist] mySQL query

[Mark Joslyn]

I want to grab some headlines from my mySQL database that fall between a
certain date range

my date field is set up YYYY-MM-DD. I would like to extract the headlines
that fall between today and 30 days ago.

I need something that is equivalent to:

Select * from myTable where myDate >= ($today - 30)

I can't have the $today variable be static since it will change as the day
changes. Essentially I am trying to capture a month's worth of headlines in
one query.

Any help would be appreciated.

Thanks,

markJ