how to choose random database id?

Question

I have a database that stores usernames, how can I randomly select a username from the database, by their ID.

So choose a random ID from the existing IDs inside of the database and return the username.

Thanks !

possible duplicate of [How to randomly select rows in SQL?](http://stackoverflow.com/questions/580639/how-to-randomly-select-rows-in-sql) — Dan Smith, Mar 13 '15 at 15:13
It limits the number of rows returned by your SQL query, 1 row (user), in this case. — Dan Smith, Mar 13 '15 at 15:15

score 1 · Answer 1 · answered Mar 13 '15 at 15:12

1

Use a simple ORDER BY.

select * from table order by rand() limit 1

answered Mar 13 '15 at 15:12

Daan

1 Answers1