From: sangprabv
Date: November 29 2008 3:15pm
Subject: Randomize by Score and DESC
List-Archive: http://lists.mysql.com/mysql/215395
Message-Id: <1227971752.29146.1.camel@MNC009>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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