select .. order by 'ALEATORIO'

[jam1138]

Tema movido desde PHP a Mysql (aunque no se especifica).

RTFM:

mysql> SELECT * FROM tbl_name ORDER BY RAND();

ORDER BY RAND() combined with LIMIT is useful for selecting a random sample from a set of rows:

mysql> SELECT * FROM table1, table2 WHERE a=b AND c<d -> ORDER BY RAND() LIMIT 1000;

http://dev.mysql.com/doc/refman/5.0/...functions.html
Echarle igual una mirada a los comentarios. Un saludo