Getting a random row (req. MySQL 3.23+)
August 22, 2000
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.