Random SQL Query

For my next project I need a sql query for mysql which retrieve random row. After some browsing, I found the sql query. Here it is:

SELECT * FROM table
ORDER BY RAND()
LIMIT 1

Aug 30, 2008 by admin