How can I best write a query that selects 10 rows randomly from a total of 600k?

28 s
28

SELECT column FROM table
ORDER BY RAND()
LIMIT 10

Not the efficient solution but works

Leave a Reply

Your email address will not be published. Required fields are marked *