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]
