Case statement not working in mysql

Question

I am writing a query to display an alias column with respect to a column value. below is my code

  CASE TRIM(channel_id)
  WHEN '' THEN 'General' 
  ELSE 'Specific'
END AS templateType

When the column channel id is empty/null the templateType column should show 'General' else should show 'Specific'

I am getting wrong output Can anyone help me please..?

Rakesh Nayak · Accepted Answer · 2013-09-17 13:11:27Z

3

CASE TRIM(IFNULL(channel_id,''))
     WHEN '' THEN 'General' 
     ELSE 'Specific'
END AS templateType

Try this..

answered Sep 17, 2013 at 13:07

Rakesh Nayak

1113 bronze badges

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

Comments

gvee · Accepted Answer · 2013-09-17 13:08:39Z

0

CASE WHEN channel_id > '' THEN
  'Specific' 
ELSE
  'General'
END As templateType

Aside:

SELECT CASE WHEN '' = '         ' THEN 'same' ELSE 'different' END

Results:

same

answered Sep 17, 2013 at 13:08

gvee

17.2k42 silver badges50 bronze badges

@sandeep.mishra Just note that this method requires no extra functions i.e. TRIM() and IFNULL()