Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Chara has posted 27 posts at DZone. View Full User Profile

Selecting a Random Row from Table in MySQL

02.13.2013
| 344 views |
  • submit to reddit 
-- source: http://www.apphp.com/index.php?snippet=mysql-selecting-random-row
SELECT * FROM TABLE
ORDER BY RAND()
LIMIT 1

  Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.

Comments

Michael Molo replied on Wed, 2013/02/20 - 8:30pm

http://www.fence-system.com/ 

"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers