Nested if in mysql

SELECT CASE col1
	WHEN 'agree' THEN 'Ok'
    ELSE
        CASE 
            WHEN col2 >= 1 THEN 'Ko'
            ELSE 'Maybe'
        END
END AS my_result
FROM table_name;

Similar codes

3 votes182 views1 answer
Make a field auto_increment mysql
SQL
0 vote246 views1 answer
Cannot start database server xampp mac os
SQL
9 votes182 views3 answers
Mysql show table column full description
SQL
2 votes168 views3 answers
Mysql unix timestamp to date
SQL
0 vote219 views1 answer
Ms sql print more than 1 variable
SQL
1 vote191 views1 answer
Sql how to replace full stop
SQL
0 vote184 views1 answer
Oracle calculate statistics on partition
SQL
1 vote177 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
1 vote192 views3 answers
Rows, INSERT INTO
SQL
0 vote170 views1 answer
Oracle free up space in tablespace
SQL