On 10/3/05, Graham Anderson <[EMAIL PROTECTED]> wrote: > what would be the best way to make MYSQL's RAND() more random ?
http://dev.mysql.com/doc/mysql/en/mathematical-functions.html: <snip> RAND() is not meant to be a perfect random generator, but instead a fast way to generate ad hoc random numbers that is portable between platforms for the same MySQL version. </snip> You might try pulling the results into a PHP array and then use PHP's random functions instead. I always got good randomness with mt_rand(). -- Greg Donald Zend Certified Engineer MySQL Core Certification http://destiney.com/
