To query records randomly, you can pass the RAND() function to the ORDER BY clause.
So that we now get only a random record, we can connect the ORDER BY with the LIMIT clause.
Example:
1 2 3 4 5 6 | SELECT * FROM mytable ORDER BY RAND() LIMIT 1 |
You may also like
Creating a New User and Giving Permissions in MySQL
Managing U.S. State and City Data with MySQL
Generating Random Numbers for Each Row in Various SQL...
Generating Random Numbers Between 1000 and 9999 in SQL
SQL: Generating Random Numbers 1-100
Simplifying Data with MariaDB: Combining Multiple Rows...
Combining Multiple MySQL Rows into a Single Field
How to Handle “Subquery Returns More Than 1...
Working With Subqueries