PHWinfo - Afficher un message - SELECT all records that occurred in the last five minutes or less

29/09/2007, 23h04

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
minutes ago

entry_date is a full timestamp

any appreciated,
AN

29/09/2007, 23h04	#1
andrecal Messages: n/a Hébergeur:	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 minutes ago entry_date is a full timestamp any appreciated, AN