[MariaDB] 조건문 CASE WHEN THEN(IF문)

[MariaDB] 조건문 CASE WHEN THEN(IF문)

/* 조건문 */
SELECT 
	CASE
    	WHEN name = '1'
        THEN 'park' 
        WHEN name = '2'
        THEN 'lee'
        ELSE 'kim'
    END AS name
FROM TEST