php - mysql last month date statement

Question

I have a DATE, how do I write a where that checks for last month until now (either the first of or just today's day -1 month)?

Answer 1

SELECT * FROM table WHERE dateField > DATE_SUB(NOW(), INTERVAL 1 MONTH)

This selects all rows that have a dateField more recent than current timestamp minus one month (so, for example, given today is 26 Sep 2009 00:56 it would give rows that are more recent than 26 Aug 2009 00:56)