I'm building a web-based admin which has membership plans. Each plan have its different longevity which means they have expiration dates.
On my MySQL database I have a table named transactions that has columns like start_date and expiry_date.
Now my question is, how will the web or the database automatically check the table if the expiry_date column is equal to date now() even if the ADMIN is not online?
Is that even possible? Answers would be so much appreciated. Thanks in advance!