Mysql help, Checking if dates are older than 2 week then delete the rows.

[Z33M@N]

I need to know how to check if dates are older than 2 weeks. Then needs to delete rows older than 2 weeks.

 

[TeNDoLLA]

CAUTION: I have not tested this and I will not quarantee it will work for sure so I sugges you TAKE BACKUP before running it. But something like this should do it (assuming your date_field is DATETIME format):

 

 

DELETE FROM some_table WHERE date_field < DATE_SUB(NOW(), INTERVAL 14 DAY);