That's because RAND() is a decimal (0.37689672). Try score*RAND().
Brent Baisley
On Nov 30, 2008, at 2:03 AM, sangprabv wrote:
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 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 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 then Rand. If Score
is an
integer, try
SELECT * FROM table ORDER BY score+RAND() DESC
This will randomize the higher scores first, followed by the lower
scores etc..
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
