I add each row to my database with a time(); stamp. How can I work out that each row is over a year old when i loop through them all.
DELETE from table WHERE date_field < NOW() - INTERVAL 1 YEAR
I'm using obbc is that still possible?
I would think there's a version for every db