Re: delete records by a column with date
| From: | Cody Caughlan | Date: | Sat, 10 Feb 2001 01:37:41 +0000 |
| Subject: | Re: delete records by a column with date | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6523@lists.php.net to get a copy of this message | ||
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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net