DELETE mySQL query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux