RAND

RAND() AS DOUBLE

Returns a random double value between 0 and 1.