On Mon, 13 Aug 2001 02:47:32 +0200, hassan el forkani <[EMAIL PROTECTED]>
wrote:
>>hello;
>>can someone please help me with this query:
>>
>>"delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) < now()"
>>
>>what i'm tryng to do is to delete all records that are 3 (or more) days old
>>i've looked around in the manual but couldn't find a "working answer", date
>>functions are only explained for select queries...
I believe that should TIMESTAMP_COLUMN(curdate(), interval 3 day) < now()"
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php