20 Jun, 2008
Delete rows older than x days or x months in MySQL
Web Development » PHP, Snippets » Delete rows older than x days or x months in MySQL
DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 5 DAY);
DELETE FROM `tablename` WHERE `created` < DATE_SUB(NOW(), INTERVAL 1 MONTH);
