Re: Trouble using RAND function

[Michael Widenius]

>>>>> "Matthias" == Matthias Urlichs <smurf@stripped> writes:

Matthias> Hi,
Matthias> Martin Ramsch:
>> The big question is, when does RAND() compute a random number?
>> Only once for the complete select statement?
>> Or once for each row?
>> 
Matthias> Obviously, currently it does the latter.

Matthias> Could you put that in the manual? (And somebody please send an erratum to
Matthias> the book author.)

I have now update the MySQL manual with this!

Regards,
Monty