Helpful Information

Category: Other Databases

select random record

I have the following code

select top 1 * from users

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

order by rand()