Getting a random row (req. MySQL 3.23+)

If you need to fetch a random row from a table using MySQL version 3.23 or newer:

select * from your_table order by rand() limit 1;

Note this does not / may not work with MySQL version older than 3.23.