order by rand() workes not satisfying
| From: | Merlin | Date: | Sun, 25 May 2003 16:35:57 +0000 |
| Subject: | order by rand() workes not satisfying | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28019@lists.php.net to get a copy of this message | ||
Hi there,
I am running mysql 3.23.49 on my server. There are some troubles with order
by rand() function. It workes, but it seems, that only the first few rows
are concidered. PHP pulls out 3 pics by random out of the table. I have
found that this are more or less the first 50 rows. All other rows apear
only verry rar.
Is this a bug in mysql?
Thanx,
merlin