i have a table where a row has current_timestamp as automatic
what i would like to do is run the following query but also add from the last 5 mins
the col with the date is called datereceived and date format is 2013-08-31 11:54:19Code:
SELECT * FROM `texts` WHERE `content` IS NOT NULL AND `messagesent` = 0
I am awful at time query's can any one assist?