> I have a table with a Date field (-mm-dd) and I would like to
retrieve
> all rows with the date less than one week ago.
>
> Something like SELECT FROM table WHERE date > one_week_ago_today.
SELECT * FROM table WHERE date > NOW() - INTERVAL 7 DAY;
---John Holmes...
--
PHP Database
I have a table with a Date field (-mm-dd) and I would like to retrieve all rows
with the date less than one week ago.
Something like SELECT FROM table WHERE date > one_week_ago_today.
This seems like it should be so simple... yet I'm not getting it.
Any help is appreciated.
Thanks,
J