MySQL random order

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


 
Ads

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.

Advertisements

Share on Google+Share on Google+

MySQL random order

Posted on: January 17, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: MySQL random order  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0

Ads

 

Ads