Hi, Gregory
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
something similar..
You can find more at
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.
Also consider creating of an index on your timestamp field, if your
table is large.
Hi
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
[EMAIL PROTECTED]
[EMAIL PROTECTED]
www.linuxpro.co.za
www.exponent.co.za
Web Hosting Solutions
Scalable Linux Solutions
www.iberry.info (support and admin)
+27 72 524 8096
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
