Re: DELETE mySQL query

On Aug 16, 2009, at 12:23 AM, "Ron Piggott" <ron.php@actsministries.org> wrote:

Is there a way to do the math in a DELETE statement (All 1 step; See my "sample" below pseudo code below). I am trying to delete the record if it is more than 3 hours old and the value of "approved" is still 0. DELETE FROM guest_book WHERE guest_book.date_submitted + 3 hours =< '$current_time' AND guest_book.approved = '0' LIMIT 1

Check out the timediff function in mysql's SQL http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff Bastien Sent from my iPod