mysql case when in select

Solutions on MaxInterview for mysql case when in select by the best coders in the world

showing results for - "mysql case when in select"
Isabell
09 Jan 2021
1SELECT CASE col1
2	WHEN 'agree' THEN 'Ok'
3	WHEN 'disagree' THEN 'Ko'
4    ELSE
5        CASE 
6            WHEN col2 >= 1 THEN 'Ko'
7            ELSE 'Maybe'
8        END
9END AS my_result
10FROM table_name;