DELETE mySQL query
am 16.08.2009 06:21:49 von Ron Piggott------=_NextPart_000_0032_01CA1E07.8BB91F50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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 =
=3D< '$current_time' AND `guest_book`.`approved` =3D '0' LIMIT 1
------=_NextPart_000_0032_01CA1E07.8BB91F50--