Develope/DB...etc...

[ORACLE] DECODE => [MySQL] CASE WHEN END

친절한 웬디양~ㅎㅎ 2011. 6. 23. 17:09
반응형

## ORACLE
SELECT
    txt
FROM
    table    
ORDER BY
    DECODE(txt,'서울',1,'경기',2,'인천',3,4)


## MySQL
SELECT
    txt
FROM
    table    
ORDER BY
    CASE txt 
        WHEN '서울' THEN 1
        WHEN '경기' THEN 2
        WHEN '인천' THEN 3
        ELSE 4
    END
 
반응형