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.