Re: What would be faster?

[Thomas Baggelaar]

This query:

SELECT * FROM `table` WHERE id >= (SELECT FLOOR( MAX(id) * RAND()) FROM `table` ) ORDER BY id LIMIT 1;

should be much faster than this query:

SELECT * FROM `table` ORDER BY RAND() LIMIT 1;

[source: http://akinas.com/pages/en/blog/mysql_random_row]
[source: http://jan.kneschke.de/projects/mysql/order-by-rand]

So why would option 2 in this case be faster?