We usually use select statement to select rows from mysql database, however, these rows are ordered by primay key, not are orderded randomly. In this tutorial, we will introduce how to select random rows from mysql.
For example, we have a table called ‘book‘, we have stored some books in this table.
SELECT * FROM `book` LIMIT 0 , 30
The rows are:
From rows, we can find these rows are ordered by primary key: book_id.
To make these rows are ordered randomly, we can do like this:
SELECT * FROM `book` order by random() LIMIT 0 , 30
The rows are:
From rows, we can find these selected rows are ordered randomly.