se vuoi estrarre 8 record casuali

SELECT * FROM nometabella ORDER BY rand() LIMIT 8