MySQL - Another way to build RAND() query

select name from random join ( select ceil(rand() * (select max(id) from random )) as id) as r2 using (id)