How can I best write a query that selects 10 rows randomly from a total of 600k?
28 s
SELECT column FROM table
ORDER BY RAND()
LIMIT 10
Not the efficient solution but works