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

0 vote260 views2 answers
Python mysql create table if not exists
SQL
0 vote292 views3 answers
Postgres date difference seconds
SQL
2 votes255 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote282 views1 answer
How to find symmetric pairs in sql
SQL
0 vote258 views1 answer
Codeigniter dbforge add index
SQL
3 votes255 views1 answer
V$session not found in oracle
SQL
11 votes264 views1 answer
Sql insert multiple rows from select
SQL
5 votes270 views1 answer
Oracle list functions
SQL
1 vote277 views1 answer
Print all records of table in mysql
SQL
0 vote275 views1 answer
Flush user resource mysql
SQL