Advanced Search

Selecting a Random Row from Table in MySQL

/ Published in: PL/SQL
Save to your folder(s)
Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT * FROM TABLE
  2. ORDER BY RAND()
  3. LIMIT 1

URL: http://www.apphp.com/index.php?snippet=mysql-selecting-random-row

Report this snippet


Comments

You need to login to view comments.