selecting a record randomly from table

For randomly selecting a record from database using RAND function , to get a one record randomly you can run the following query :

Code:

SELECT * FROM Department where  type='active' ORDER BY RAND() limit 1

You can also select more records:

Code:

SELECT * FROM Department where  type='active' ORDER BY RAND() limit 10

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : selecting a record randomly from table
Randomly generated rows and columns in Array -
error in inserting record -
Timeout error while updating record in SQLServer in ASP.NET -
Selecting a Database in php -
Selecting a Domain Name at the Time of Registration -
Draw Bezier Curve and selecting the points with mouse click -
row highlight of table -
table row hover -
Creating table using div tag -
Div Table with css row span -

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com