MySQL select 10 random rows from 600K rows fast SELECT column FROM table ORDER BY RAND() LIMIT 10 Not the efficient solution but works