Randomness

Team Member Joined: 06 Jan 2002 Posts: 2564

That's wierd. I've always seen it used as though it was random... In fact I've never noticed it not being random (but then I probably don't pay enough attention Very Happy

). Anyone know? Question

Posted: Sun Mar 09, 2003 11:52 am (21 years, 1 month ago)

Interestingly its the first record in the table out of about 30 that is appearing more often than not

http://www.mysql.com/doc/en/Mathematical_functions.html#IDX1255 wrote:

You can't use a column with RAND() values in an ORDER BY clause, because ORDER BY would evaluate the column multiple times.

maybe this is why, I was selecting specific columns

it also says:

Quote:

RAND() is not meant to be a perfect random generator