SELECT * FROM TABELLA ORDER BY RAND() LIMIT 8

ciao