-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 score*RAND().
[JS] That in itself
[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 SELECT * FROM table ORDER
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
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
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
Date: Sat, 29 Nov 2008