Getting a Random Row in a Table

[Petcube]

If you know how to get a random row from a database without saying where id = a random number, please post it here 🙂 I'm currently programming a game that requires this. I've talked to about 3 other programmers and none of them can think of a function to do it. 😕

[[deleted]]

select * from table order by rand() limit 1