PHP MySql query for random record from database table
The simplest way of selecting random rows from the MySQL database is to use “ORDER BY RAND()” clause in the query.
SELECT * FROM `table` ORDER BY RAND() LIMIT 0,1;
By Keenlio, September 5, 2014
What do you think?