MySQL random order

In MySQL we can get the rows records in a random order by using the method RAND() of MySQL.

MySQL random order

MySQL random order

     

In MySQL we can get the rows records in a random order by using the method RAND() of MySQL. In the following example, we will describe how you can use RAND() function to fetch records from the database.

To explain the use of RAND() we have created a table "mca". 

Here is the full table structure and query for creating the table as given below

 

 

 

 

 

 Query  CREATE TABLE `mca` (
`id` bigint(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`subject` varchar(255) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `mca` */

insert into `mca`(`id`,`name`,`subject`) values (1,'Amit','Computer '),(2,'Ramesh','Computer '),(3,'Suman','Computer '),(4,'Vineet','Java'),(5,'Sandeep','C++');
 

Output

 

Now we can execute the Update query on the table "mca"

 Query SELECT * FROM mca ORDER BY RAND();
 Output

You can see from the output that it selects the row from the database in the random order.