Update my question to reference me and explain better what I want to do.
In my table I have a field called days, I want every 24 hours to run and trigger and subtract that field in 1 if it has a 30 subtract 29 and so on, but I do not know how to do it, I know that it is a while but I do not know how to do it in mysql
While days > = 0 Do I do not know how to add the following code to the trigger with an update for the days field
floor(((date + (86400 * 30)) - unix_timestamp()) / 86400) as expire_days