SQL Query

[boomers]

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

 

[AllValley]

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]

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

 

[Barts]

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]

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

select * from table where some_key = rand()