MYSQL CASE THEN statement with multiple values

mysql

Solution

No, it is just a single value. Additionally, it is contradictory to use "multiple columns" and name those multiple columns as `column_1`, right? :)

You can use another column to store the other id with (a similar case) and use nulls to represent the `else` values, just like you're doing now.

Example:

CASE 
    WHEN wall.type="bk" 
    THEN books.id1
END as column_1,
CASE 
    WHEN wall.type="bk" 
    THEN books.id2
END as column_2

Check the official documentation for more information.

Problem

I am trying go select multiple values with `CASE` statement. I noticed we cannot do ``` CASE WHEN wall.type="bk" THEN books.id1,books.id2, // and so on END as column_1, ``` Is there a way to do `THEN` with multiple columns or do we need to simply write a bunch of `CASE THEN` statements? that seems messy

Original source