SORT BY dateiendung (".mp3") ?

[André Laugks]

--> Berichtigung

SELECT IF(SUBSTRING(string, LENGTH(string)-3)='.mp3', '0', '1') AS temp_spalte, string AS ausgabe FROM mp3 ORDER BY temp_spalte ASC, interpreter ASC;

SELECT IF(SUBSTRING(interpreter, LENGTH(interpreter)-3)='.mp3', '0', '1') AS temp_spalte, interpreter FROM mp3 ORDER BY temp_spalte ASC, interpreter ASC;

MfG, André Laugks