Querying rows that are 5 minutes old or more

Querying rows that are older than 5 minutes

I recently had a couple separate tasks running on the same database and I wanted to make sure that the second task did not interefere with the other task.

To help with this I made sure that the second task waited for 5 minutes before grabbing the data.

Here is how you do that in MySQL

SELECT * FROM your_table_name WHERE datecreated <= NOW() - INTERVAL 5 MINUTE;