SELECT all records that occurred in the last five minutes or less
I have a table with a TIMESTAMP entry, and I would like to find a
query that will look at this table and only return results that shows
the TIMESTAMP to be five minutes ago or less.
Something along these lines:
SELECT * FROM table_name WHERE entry_date BETWEEN NOW() AND NOW()-5
entry_date is a full timestamp
any help appreciated,