Re: Randomize by Score and DESC

[mos]

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