Selecting a Random Row from Table in MySQL
Join the DZone community and get the full member experience.Join For Free
Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.
-- source: http://www.apphp.com/index.php?snippet=mysql-selecting-random-row SELECT * FROM TABLE ORDER BY RAND() LIMIT 1
Opinions expressed by DZone contributors are their own.