SELECT * FROM table ORDER BY rand() LIMIT 10;