MySQL Order By (komplex)

[Rouven]

Also bei MySQL siehts laut http://dev.mysql.com/doc/mysql/en/case-statement.html so aus:
SELECT ...,
CASE
   WHEN type = 'C' THEN 1
   WHEN type = 'R' THEN 2
   ...
END CASE AS sort_col
FROM...
ORDER BY sort_col

MfG
Rouven