Re: [PHP] How to delete 3 months old records in my database?
[email protected] (Karl-Arne Gjersøyen)
| Newsgroups | php.general |
|---|---|
| Message-ID | <CAN78Z6Avapf9E35Zk-zKiaiJD9RNq3PzEjY-UNn59YRmeG_dCw@mail.gmail.com> |
2013/8/2 Dušan Novaković <[email protected]> > $query = "DELECT FROM `__table_name__` WHERE `__date__` BETWEEN NOW() - > INTERVAL 3 MONTH AND NOW()" > This delete everything from now and 3months backwards. I want to store 3 months from now and delete OLDER than 3 months old records. Karl