> I have a table with a Date field (yyyy-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 Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to