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 <mos99@stripped>
To: sangprabv <sangprabv@stripped>, mysql@stripped
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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.