2. select count(*) to get # of rows
3. use the app to generate X # of integers between 1 and last row
4. select * from table where column_x in (rand1, rand2, rand3, ...)
Thank you for reading this article Faster way of getting random rows in mysql instead of using order by rand() With URL http://x-tutorials.blogspot.com/2005/04/faster-way-of-getting-random-rows-in.html. Also a time to read the other articles.


0 comments:
Write your comment for this article Faster way of getting random rows in mysql instead of using order by rand() above!