Re: Selecting a random row

> Tthe problem with this is that this is not very random.
> If the uids 30000 to 39999 have been missing, but
> the uids are more or less contiguous apart from that,
> the uid 40000 would be 10000 times more likely to be selected
> than average.

There are some gaps but distribution of them is quite uniform. And results
seem to be random enuff for this particular purpose.

> Maybe using an OFFSET of (count(*) * random()) and a LIMIT 1
> could be practical.

Something like OFFSET (random() * 10) could be used for additional
randomness of course.

|\__/|
( oo ) Kari Lavikka - tuner(at)bdb(dot)fi
__ooO( )Ooo_______ _____ ___ _ _ _ _ _ _ _
""