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

1 vote113 views3 answers
Mysql Server Start
SQL
0 vote117 views1 answer
Sql how to get courses that i have made prerequisites
SQL
5 votes111 views1 answer
Oracle list packages
SQL
0 vote119 views1 answer
Use between operator in mysql
SQL
11 votes119 views3 answers
Sql line numbers
SQL
19 votes114 views5 answers
Change column name mysql command line
SQL
1 vote116 views1 answer
Sql server locks
SQL
2 votes120 views1 answer
How to find constraints on a table in oracle
SQL
0 vote142 views1 answer
Postgres list all triggers
SQL
1 vote122 views1 answer
Postgresql escape single quote
SQL