La funziona RAND() di mysql fa abbastanza schifo.

http://dev.mysql.com/doc/mysql/en/ma...functions.html

RAND() is not meant to be a perfect random generator, but instead a fast way to generate ad hoc random numbers that will be portable between platforms for the same MySQL version.