You had the query right:

DELETE FROM <table> WHERE CUR_DATE() > <date_column>

would do it...

/cody caughlan

"Manuel Dominguez Jr." wrote:

> there is a column in a mysql database called expires that has type date and
> i was wondering what php code would be needed to delete all records that
> have dates that have expired
>
> something like
>
> delete from expires where curdate > expires;
>
> something like that.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to