>-Original Message-
>From: Brent Baisley [mailto:[EMAIL PROTECTED]
>Sent: Saturday, December 06, 2008 11:35 AM
>To: sangprabv
>Cc: mos; mysql@lists.mysql.com
>Subject: Re: Randomize by Score and DESC
>
>That's because RAND() is a decimal (0.37689672). Try
From: mos <[EMAIL PROTECTED]>
To: sangprabv <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject: Re: Randomize by Score and DESC
Date: Sat, 29 Nov 2008 13:05:09 -0600
Mailer: QUALCOMM Windows Eudora Version 6.0.0.22
At 09:15 AM 11/29/2008, sangprabv wrote:
Hi,
I have a query like this &quo
Hi,
Thans for the reply, I have tried it but I don't see the RAND() to be
work. This list is always the same. TIA
Willy
-Original Message-
From: mos <[EMAIL PROTECTED]>
To: sangprabv <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject: Re: Randomize by Score and DESC
At 09:15 AM 11/29/2008, sangprabv wrote:
Hi,
I have a query like this "SELECT * FROM table ORDER BY score DESC,
RAND()" The aim is to randomize the result by score with descending
order. But it doesn't work. What missed here? TIA.
Willy
Willy,
That is because you are ordering by Score
