SQL Query

boomers · Feb 17, 2006

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

AllValley · Feb 17, 2006

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....

Kate · Feb 17, 2006

Have a look here: http://www.namepros.com/programming...-quote-database-php.html?highlight=order+rand

Barts · Feb 17, 2006

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 · Feb 18, 2006

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

Code:

select * from table where some_key = rand()

SQL Query

Established Member

Established Member

Domainosaurus RexTop Member

Established Member

Established Member

siap.xyz

e-speech.com

hwgj.com

FremontCarpetCleaning.com

ManhattanBeachLocksmith.com

zynfi.com

Alis.ai

CyberByte.net

GreatSiding.com

nexsurf.com

Similar threads

We're social

siap.xyz

e-speech.com

hwgj.com

FremontCarpetCleaning.com

ManhattanBeachLocksmith.com

zynfi.com

Alis.ai

CyberByte.net

GreatSiding.com

nexsurf.com

Pinned

Appreciation

Agreement

Answers

Relevance

Reaction

Status

Feeling