//Seleziona 5 righe random dalla tabella "your_table_name"
SELECT * FROM ‘your_table_name’ ORDER BY RAND() LIMIT 5

fonte: www.sastgroup.com