Randomize Displaying Rows

[inveni0]

Is there a way to randomize which table row is displayed in a query?

For instance, if I have a table with 10 rows, and each row has just one column with random numbers or letters in it, can the page load one row and then, when refreshed, load another?

[jatar_k]

with a small set of results you could select them all into an array and then display a random row from the array. With a larger set it may be slow.

[vevs]

if you are talking for a mysql table, then you can use
SELECT * FROM TABLE ORDER by rand() LIMIT 0,1
which will return a random row from the table

[inveni0]

Works great, thanks!