Random selections 1

[KingSlick]

I am trying to select a certain number of records out of a table. The catch is that I want the records to be chosen at random. Is there a way in mysql that would allow me to a random selection?

Thanks in advance
-SM

 

[colorplane]

Sure, in your select statement you can add [tt]ORDER BY RAND() LIMIT 10[/tt] to the end where 10 is your certain number.

 

[KingSlick]

I kept trying RANDOM(). I knew it was something that easy.

Thanks