Hmm.. I think you just should add something like 'create_time >
DATE_SUB(NOW(), INTERVAL 20 MINUTE)' to a where clause of your query. Or
You can find more at
Also consider creating of an index on your timestamp field, if your
table is large.
> What, is the easest way to select all the records created in the last 20 min
> stay based on a column that has a timestamp record.
> Many Thanks
> Gregory Machin
> Web Hosting Solutions
> Scalable Linux Solutions
> www.iberry.info (support and admin)
> +27 72 524 8096