Hi!
> "Ulf" == Ulf Harnhammar <[EMAIL PROTECTED]> writes:
Ulf> On Sun, 27 Jan 2002, Michael Widenius wrote:
>> One way to do this is to do as follows:
>> SELECT something FROM sometable WHERE somevar=somevalue ORDER BY
>> RAND() LIMIT 10
Ulf> OK. I still think that my extended LIMIT syntax
On Sun, 27 Jan 2002, Michael Widenius wrote:
> One way to do this is to do as follows:
> SELECT something FROM sometable WHERE somevar=somevalue ORDER BY
> RAND() LIMIT 10
OK. I still think that my extended LIMIT syntax would be a good idea,
because ORDER BY RAND() does not seem to be very fast
ailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 23, 2002 10:09 AM
To: [EMAIL PROTECTED]
Subject: Using LIMIT to select random rows
This is a suggestion for a small addition to MySQL's syntax which I'm
proposing, unless someone is kind enough to show me that there already
is
equivalent fun
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Ulf Harnhammar writes:
>> This is a suggestion for a small addition to MySQL's syntax which I'm
>> proposing, unless someone is kind enough to show me that there already is
>> equivalent functionality somewhere else in
