Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Mysql-example MySQL random order

Related Tutorials


 
 

Share on Google+Share on Google+

MySQL random order

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

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.

Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: January 17, 2009

Related Tutorials

Discuss: MySQL random order  

Post your Comment


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