PDA

View Full Version : select random record



esthera
Mar 16th, 2005, 06:37 PM
I have the following code

select top 1 * from users

how can I instead of selecting the top just select a random record?

DigitalBliss
Apr 2nd, 2005, 04:09 AM
order by rand()