I have done this so many times.. SELECT * FROM `support_start` WHERE TO_DAYS(NOW()) - TO_DAYS(date) > 7
I have scoured (more like glanced :-)) at the docs on <http://www.mysql.com/doc/en/Date_and_time_functions.html> and can not seem to find how to get all records where a timestamp(14) is older than x minutes. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]