Select WHERE DATE &lt; last week.

Select WHERE DATE < last week.

Anon

I have been reading the MySQL manuals and such, but have yet to find a straightforward way to select all records where a timedate field is less than x number of days or weeks old.

http://www.mysql.com/doc/D/a/Date_calculations.html

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Am I missing something?

Thanks!

Anon

I'd use PHP functions to do all of the date manipulation, so that as far as MySQL is concerned, they're only numbers, not dates.

Anon

Right at the top of 2nd link you provided is an example that will do what you want...

"Here is an example that uses date functions. The query below selects all records with a date_col value from within the last 30 days:"

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