SQL Query

boomers · 02-17-2006, 12:11 PM

Is there a way to select a random record from within an SQL database?

AllValley · 02-17-2006, 12:24 PM

Might try looking at the mysql.org website.

I cant think of one off hand though.

You could create a php/js script that generated random numbers, and have it feed those into a variable for calling record numbers....

sdsinc · 02-17-2006, 02:27 PM

Have a look here: http://www.namepros.com/programming/...ght=order+rand

Barts · 02-17-2006, 03:20 PM

Which DBMS? If you're talking about MS SQL, do a order by newid() trick

"select * from sometable order by newid()"

If you're talking abouit MySQL use rand:

"select * from sometable order by rand()"

Tree · 02-17-2006, 05:51 PM

If you're looking to select just one record do this query

Code:

select * from table where some_key = rand()

02-17-2006, 12:11 PM	THREAD STARTER #1 (permalink)
boomers NamePros Regular Join Date: Jun 2005 Posts: 518	SQL Query Is there a way to select a random record from within an SQL database?

02-17-2006, 12:24 PM	#2 (permalink)
AllValley NamePros Member Join Date: Feb 2006 Location: Chicago IL Posts: 73	Might try looking at the mysql.org website. I cant think of one off hand though. You could create a php/js script that generated random numbers, and have it feed those into a variable for calling record numbers.... __________________ Hassle Free Computing and Web Solutions for Personal and Business! Rochelle Network Communications!

02-17-2006, 02:27 PM	#3 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,963	Have a look here: http://www.namepros.com/programming/...ght=order+rand __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

02-17-2006, 05:51 PM	#5 (permalink)
Tree NamePros Regular Join Date: Feb 2006 Location: Atlanta, GA, USA Posts: 335	If you're looking to select just one record do this query Code: select * from table where some_key = rand()

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Free cPanel, RvSkins, Fantastico, SQL Hosting!	dc1pop	Web Hosting Offers	0	06-26-2005 07:29 AM
DB Error: Bad SQL Query: DELETE FROM 4images_sessionvars WHERE session_id NOT IN ...	none1983	Programming	8	06-02-2005 11:41 AM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Web Hosting Discussion	1	12-07-2004 03:21 PM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Webmaster Tutorials	0	12-06-2004 08:58 PM
HELP!!!!!! DB Error? Bad SQL Query?	logos	The Break Room	5	08-25-2004 07:48 PM

02-17-2006, 03:20 PM	#4 (permalink)
Barts NamePros Member Join Date: Feb 2006 Location: Online Posts: 118	Which DBMS? If you're talking about MS SQL, do a order by newid() trick "select * from sometable order by newid()" If you're talking abouit MySQL use rand: "select * from sometable order by rand()"

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)