A trigger is something that gets executed when a record is either inserted, updated or deleted in a table. What you want to do is to schedule a process to execute periodically which looks at the records and identifies those that have not been updated within the period your are looking for. In MySQL have a look at EVENTS which allows you to schedule SQL code to scheduled within the database.