Page 1 of 1

order mysql results problem

Posted: Wed Apr 21, 2004 7:34 pm
by potato
i have a mysql query, where i want to sort the results by score.
But if 2 scores are the same, he sort by the order the lines where inserted in the table.
How can i make such a query where he first looks the score & if the score is the same, he order by name.

somebody can help me?

Posted: Wed Apr 21, 2004 7:39 pm
by Unipus
ORDER BY score, name

Posted: Wed Apr 21, 2004 7:54 pm
by potato
thax