CASE Function in mysql query

Question

I can't get the result I want from the following query. Can I get a little help, please? thank you.

$sql = "SELECT id, 
                 CASE 
                    when Rcon = '' then '0',
                    when Rcon = 'x' then '1',
                    when Rcon = '2x' then '2',
                    when Rcon = 'x3' then '2',
                    when Rcon = 'x,x3' then '3',
                    when Rcon = 'x4' then '3' 
                    ELSE Rcon END AS Rcon
FROM mytable";

In else part, I tried to give an option if there is any unexpected data. — Max
– Max, Commented Feb 1, 2019 at 13:57
if you just read the error message raised from mysql you can get what is the error. — user2399035
– user2399035, Commented Feb 1, 2019 at 15:08

Martin · Accepted Answer · 2019-02-01 13:57:43Z

1

You've got a problem with your CASE statement.

SELECT  id, 
        CASE 
          when Rcon = '' then '0'
          when Rcon = 'x' then '1'
          when Rcon = '2x' then '2'
          when Rcon = 'x3' then '2'
          when Rcon = 'x,x3' then '3'
          when Rcon = 'x4' then '3' 
          ELSE Rcon 
        END AS Rcon
  FROM mytable;

Note that I have removed the commas (,) from the end of each line of the CASE statement. Commas are not valid in a case statement.

answered Feb 1, 2019 at 13:57

Martin

16.5k1 gold badge33 silver badges51 bronze badges

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

2 Comments

Max Over a year ago

so just the comma does the trick? thank you, Martin. this works!

Martin Over a year ago

@Max Yes it's just the commas - you don't need them in a CASE statment

Collectives™ on Stack Overflow

CASE Function in mysql query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related