2012.07.13 21:47:14 (*.72.111.130)
29474
--------------------------------------------------------------
CASE WHEN condiion THEN expr1 ELSE expr3 END
--------------------------------------------------------------
SELECT (CASE 2 WHEN 1 THEN "one" WHEN 2 THEN "two" ELSE "more" END) as ans;
-> two
SELECT CASE WHEN 1<0 style="color: rgb(255, 0, 0);">THEN "true" ELSE "false" END;
->false
--------------------------------------------------------------
IF(condition,expr,expr1)
--------------------------------------------------------------
SELECT IF(0.1<>0,1,0);
-> 1
SELECT IF(STRCMP('test','test1'),'no','yes');
-> no
select * from 테이블
ORDER BY (
CASE 이름 WHEN '김한수' THEN '1'
WHEN '김문중' THEN '2'
WHEN '김만수' THEN '3'
WHEN '김도직' THEN '4'
END);