MySQL: quick random rows

January 22nd, 2007

There’s a quicker alternative to using ORDER BY RAND() in MySQL. My only concern is just how random MySQL’s random generator is since the documentation has the following to say.

RAND() is not meant to be a perfect random generator, but instead is a fast way to generate ad hoc random numbers which is portable between platforms for the same MySQL version.

Sorry, comments are closed for this article.