I have some records in my MySQL db that contain dates for upcoming events.. I need a way to query upcoming events and expire them from the query once the date passes without necessarily deleting them from the database. (I'm publishing the next 5 upcoming events to the homepage via 'LIMIT 5').
Is there an easy way to do this within a MySQL db query? This section of the site (both insert record, display, current query, etc) is all created with ADDT.
And of course you need a trigger if you want this to happen automatically. For instance what other element of the site / app can you tie the new function to so that it operates when some common event is executed.
I don't know of any way to get a function to work without some interaction so you need to figure that into your deployment plan.