Replies To: Picking a random row in my sql

Re: Picking a random row in my sql

Posted 20 March 2010 - 05:17 AM

I was going to suggest using MySQL's rand() function, but see this link about fast random results on large tables:http://www.greggdev....ticles.php?id=6
I would have used mysql_num_rows instead of selecting "as max_id", but that's just nitpicking.

Re: Picking a random row in my sql

Posted 20 March 2010 - 05:22 AM

CTphpnwb, on 20 March 2010 - 04:17 AM, said:

I was going to suggest using MySQL's rand() function, but see this link about fast random results on large tables:http://www.greggdev....ticles.php?id=6
I would have used mysql_num_rows instead of selecting "as max_id", but that's just nitpicking.