Fastest way to get random row in MySQL

[markjia]

I need to be able to obtain the contents of a row in a MySQL table chosen at random, and efficency is a concern, so I was wondering what the best way of doing this would be.

[Anon]

SELECT * FROM table_name ORDER BY RAND() LIMIT 1