Re: Find record between 10 minutes

[EMAIL PROTECTED] wrote: Hi, I have a table with records dated 01-01-2007 00:00:00 to 01-02-2007 23:59:59. What I want to do is grab 1 random record in every 10 minutes between the date. Please help me. Regards, Willy Does it really need to be random? This works from me: mysql> select `da

Re: Find record between 10 minutes

Good morning, Willy - If you're using some sort of scripting language, like PHP, this would be easily done by starting a variable at the beginning of the date range, then repeating the below query and incrementing the variable by 10 minutes each time through a while loop until you've passed the ot

Find record between 10 minutes

Hi, I have a table with records dated 01-01-2007 00:00:00 to 01-02-2007 23:59:59. What I want to do is grab 1 random record in every 10 minutes between the date. Please help me. Regards, Willy -- www.sangprabv.web.id www.binbit.co.id -- MySQL General Mailing List For list archives: http://li