nedf23
11/6/2013 - 12:50 PM

Select Random Row

Select Random Row

SELECT  r.*
FROM    random AS r
JOIN    (SELECT RAND() * (SELECT MAX(id) FROM random) AS id) AS r2
WHERE   r.id >= r2.id
LIMIT   1;