[thelist] Setting records to expire after a specific time?

[David Kutcher]

That all depends on the database.

If you're using one that allows stored procedures, use that.

If not, you'll have to figure out a creative means of doing it (like if
using MySQL).

Then again, just because they've expired, doesn't mean you should
necessarily delete them.  Possibly pitch the client on "archiving" them or
adding a time clause in your queries.  I've often find that when you explain
ways to the client of hiding old data (maybe a job that that is older than
30 days or something like that) without deleting it, they're happier.

David