19 November 2012

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)
Provided by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)