SELECT CASE in MySQL

Question

I am running a simple query having SELECT CASE

SELECT DEPT_ID, DEPT_NAME = 
    CASE DEPT_NAME
        WHEN 'PBG' THEN 'Best Dept'
        ELSE 'Usual Dept'
    END
FROM DEPARTMENTS;

However, the output is not satisfactory. All 0 is coming in output

What is wrong in query ?

Otherwise the table has below data

SELECT * FROM DEPARTMENTS;

jarlh · Accepted Answer · 2016-08-19 08:52:54Z

5

Move the column alias DEPT_NAME. It should be placed after the case expression, not before:

SELECT DEPT_ID, 
    CASE DEPT_NAME
        WHEN 'PBG' THEN 'Best Dept'
        ELSE 'Usual Dept'
    END as DEPT_NAME 
FROM DEPARTMENTS;

answered Aug 19, 2016 at 8:52

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Great. (Did you perhaps use SQL Server specific syntax?)