> 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