Removing Data After A Certain Period Of Time

What I want to do is run a query that inserts data into my database, but removes itself on a set date. Is there any way to do this?

Basically, I have something like this:

INSERT INTO table (blah, blah2) VALUES (blah blah, 1)

I would like to do something like:

INSERT INTO table (blah, blah2) VALUES (blah blah, 1) {{{ INSERT CODE TO MAKE VALUES GO AWAY WHEN CURRENT TIME = SET TIME TO GO AWAY }}}

There is an alternative to this if I have to. This is all for a PHP script, and instead of having MySQL automatically remove the data, I could add a time to remove to the table, insert the value for it in the INSERT query, and run a query on the index page consisting of something like

<?php
$timeToRemove = SELECT_TIME_TO_REMOVE_FROM_DB;
if($currentTime => $timeToRemove)
{
REMOVE;
}
?>

so that every time someone hit the index page, it checks if it is time to remove the values from the DB and if it is, it does so. But of course, that adds an extra query/queries, and I'd like to avoid that.

Edit: It may be useful to note that this is for a message board system, and I am dealing with making usergroup changes temporary. So instead of removing the values, perhaps it would be more useful if I could simply have MySQL reverse itself after a certain time has passed.

But that seems unrealistic for some reason now that I think about it, so the alternative may be my best choice. Any suggestions from you all would be nice as well, if you've any ideas.

• Dumping Data From A Certain Time Period
• Time Period Results
• Generating DAILY Min&amp;Max Over A Period Of Time, Based On A "DateTime" Field
• Room Reservation: See If A Time Period Is Open For A Particular Room...
• Display Period In Month Into Period In Year And Month
• Removing MySql Data
• Does Mysql Store Max Size For Data Type Each Time, Or Only What Is Needed For Specific Data?
• Add A Period 5 Places From The Right?
• Grouping By A Date Period
• Selecting First Occurance In A Given Period Of Record
• Date Calculation For 24 Hour Period
• Select And Displaying 90 Day Interval Over A Period
• Selecting First Occurance In A Given Period Of Record (log Sessions And User)
• Data Time
• Time Data Type
• Data Type For Storing Time
• Displaying Row Data Only When Occuring First Time....
• Size Of Data Type 'Time'
• Real Time Data Feed
• Data Containing Disjoint Time Intervals
• Any Way To Insert Data Into Two Tables At The Same Time?
• Reduce Data Loading Time
• Inserting Time Data Into MYSQL
• Real-time Data Store And Analyize
• Real-time Automatic Conditional Data Manipulation
• Creating Datetime Data Object From Date And Time Objects
• Converting Time Date Values To An Absolute Number For Data Retrieval
• Removing Subqueries
• Removing End-of-lines
• Removing AUTO_INCREMENT
• Removing Emails
• Removing Fields
• Removing Spaces
• Removing A Domain
• Removing Users
• Removing Old Versions
• Removing Last Character
• Removing 14,000 Entries
• Removing MySQL
• Setting Up / Removing
• Removing Rows
• Removing A Record
• Removing Old Items
• Removing Mysqld-net.exe
• Removing Space In Varchar
• Removing All The Default Stopwords
• Ordering Results (removing 'the')
• Removing Auto-increment
• Removing Extra Numbers In Avg()