Hi Thanks for you support hope you have a grate day .. On 3/7/06, Martijn Tonies <[EMAIL PROTECTED]> wrote: > > Hello Gregory, > > > > 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. > > select * from mytable > where some_timestamp > date_add(current_timestamp, interval -15 minute) > > Martijn Tonies > Database Workbench - development tool for MySQL, and more! > Upscene Productions > http://www.upscene.com > My thoughts: > http://blog.upscene.com/martijn/ > Database development questions? Check the forum! > http://www.databasedevelopmentforum.com > >
-- 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