At 02:08 AM 9/20/2002, you wrote:
>Hi all,
>
>
>anyone knows a good method to retrieve 1 random selevted record out of
>thouseands?
>
>right now I'm using
>
>select ID from table ORDER BY rand() LIMIT 1
>
>however, this seems like a very slow method, like mysql first organizes a
>few thousand reco
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm
(http://www.ezmlm.org)
From: "W. Enserink" <[EMAIL PROTECTED]>
Date: Fri, 20 Sep 2002 09:08:53 +0200
anyone knows a good method to retrieve 1 random selevted record out of
thouseands?
right now I'm using
select ID from
Hi all,
anyone knows a good method to retrieve 1 random selevted record out of
thouseands?
right now I'm using
select ID from table ORDER BY rand() LIMIT 1
however, this seems like a very slow method, like mysql first organizes a
few thousand records in a random 1 and only returns 1
Any