SQL Order by

[Franzi]

Danke für die Hilfe!!

SELECT *,
IF(room.name = 'Sopran',1,
IF(room.name = 'Alt 1',2,
        IF(room.name = 'Alt 2',3,
        IF(room.name = 'Tenor',4,
IF(room.name = 'Bass',5,0)
)))) AS order_id
FROM 'TABELLE'
ORDER BY order_id
lg

PS::(Mir ist heute Langweilig)

Natürlich statt 'room.name' => "stimmen" Feld nehmen. Vergessen zu ändern ;)

lg