Hello and thanks for taking time to read this question.
I am using MySQL, and I want to sort results using ORDER BY to one specific column, but the results must be ordered according an specific criteria to this column. For example, to the following table, I want to ORDER BY 'group'
, showing first the 9,7,6 'group' items
and, in the end 10,8,5 'group' items
:
names group
--------- ------
susanita 10
miguelito 5
mafalda 7
manolito 8
libertad 6
felipe 9
guille 8
thanks in advance.
Best Answer
I took your sample data, loaded it into a table called mytable and ran it.
Here are the results:
Give it a Try !!!
UPDATE 2011-09-06 12:33 EDT
Here is another approach:
This will force any groups other than 9,7,6,10,8,5 to appear at the very bottom of the query.
UPDATE 2011-09-06 14:39 EDT
Hey @Nick, yours works as well against my sample data !!!