selecting a random row

[doobster]

What is the fastest way to select a random row from a mysql table?

I do not want to use the rand() function as it is a very large table in the database and research yields that that function will be to slow.

[ir4z0r]

you should use the php random functions then

// get rowcount, store it on $rowcount
$random = rand(0,$rowcount-1);
$query = "SELECT * FROM table LIMIT " . $random . ",1";