MySQL in a Nutshell

Name

RAND( )

Synopsis

RAND([seed])

This function returns a random floating-point number from 0 to 1. A seed number may given with the function, but the results will be the same each time.

SELECT RAND( ), RAND( );
+------------------+------------------+
| RAND( )           | RAND( )           |
+------------------+------------------+
| 0.29085519843814 | 0.45449978900561 |
+------------------+------------------+

Note that rerunning this statement with the same seeds will produce the same results.