Selecting a random result that changes each time the page refreshes

[eluser]CroNiX[/eluser]
There is no efficient way to do this in mysql AFAIK. From what I've read, the best way is to select MAX(id) in one query, then use php to get a random number between 1 and that number and then do a 2nd query to get the record. However, that assumes no rows have been deleted.