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]
