SQL for collecting random record from a table

Many times we have to collect a random record from mysql database. How to get the random record?
Here we have to use rand() function and along with it we will use limit query to restrict our result to one record. Randome funciton is used along with order by clause to generate randome records. This will work well in other database also. Here is the query. We have added on where clause also.

SELECT * FROM student where status='yes' ORDER BY RAND() limit 1

To get 10 random records from the same table.

SELECT * FROM student where status='yes' ORDER BY RAND() limit 10

Let us learn how to randomly update records of a table in Part II

This article is written by plus2net.com team.

plus2net.com

▼ More on getting records from table with different combinations of commands

select SQL query to collect records from the table
Adding restriction by using select SQL query to collect records from the table
Between two ranges in query
Distinct SQL command to exclude duplicate records
Grouping records by using group by query
Having command to group data with count, avg etc
SQL inner join to get matching records
IF Condition checking in Query
Matching a set of string matching data of a column
case : Matching value or condition with Select
Limiting number of records to display with starting and ending range
matching records with wildcard
Pattern matching using REGEXP
Order By to get records in descending or ascending order
Using OR AND logical operators in Query
Random records from table by rand query
Subqueries used in SQL with examples
Checking if matching record exists or not in a table
Counting number of records present in a table

Dev Pandey	12-04-2012
select * from tableName order by rand() limit 0,1;

alex	11-04-2013
What is the use of Random records ?

Queries INSERT UPDATE

Aggregate Queries AVG ( Average ) SUM MIN MAX

✖

We use cookies to improve your browsing experience. . Learn more

HTML

MySQL

PHP

JavaScript

ASP

Photoshop

Articles

FORUM . Contact us