Return random records in MySQL

Interesting Written with a loving hand by kitt some time around 16:11 on 29 December 2007

Works only for relatively small tables.

SELECT field1, field2, field3 FROM mytable WHERE status = 1 AND otherfield = 'somevalue' ORDER BY RAND();