You could use MySQL's event scheduler either: to automatically delete such records when they expire: CREATE EVENT delete_expired_101 ON SCHEDULE AT ... ... <看更多>