iling List; Ravi Raman
Subject: Re: Selecting random rows with MySQL 3.22?
Hi,
> for mysql < 3.23 you can do something like this.
>
> select ID, ID*0+rand() as rand from partner order by rand limit 1
Thanks a million for the speedy response! It works like a charm!
I don't q
Hi,
> for mysql < 3.23 you can do something like this.
>
> select ID, ID*0+rand() as rand from partner order by rand limit 1
Thanks a million for the speedy response! It works like a charm!
I don't quite understand how it works though... Could anyone explain? I
really don't like knowing som
It has been. Check the archives for 2-3 weeks ago.
Cal
http://www.calevans.com
-Original Message-
From: Chris Boot [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:16 PM
To: MySQL Mailing List
Subject: Selecting random rows with MySQL 3.22?
Hi,
I'm sure this has been cover
Hi.
for mysql < 3.23 you can do something like this.
select ID, ID*0+rand() as rand from partner order by rand limit 1
have fun.
-ravi.
-Original Message-
From: Chris Boot [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 3:16 PM
To: MySQL Mailing List
Subject: Selecting random