How to select random record from database table

To select random row from a MySQL table use the following query:

mysql> SELECT col1, col2 FROM table_name ORDER BY rand() LIMIT 1;