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
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 126.96.36.199
At 09:15 AM 11/29/2008, sangprabv wrote:
>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.
That is because you are ordering by Score then Rand. If Score is an
>SELECT * FROM table ORDER BY score+RAND() DESC
This will randomize the higher scores first, followed by the lower scores etc..