Tuesday, August 27, 2013

How do you select random 10 rows in MySQL?

SELECT *
FROM <TableName>
ORDER BY RAND()
LIMIT 10;

No comments :