mysql random select

ORDER BY RAND() combined with LIMIT is useful for selecting a random sample of a set of rows: SELECT * FROM <tablename> ORDER BY RAND() LIMIT 1000; Note that RAND() in a WHERE clause is re-evaluated every time the WHERE