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 vote215 views1 answer
Sql query to find duplicate email address
SQL
8 votes181 views1 answer
Oracle add month
SQL
3 votes226 views2 answers
Synonym oracle
SQL
0 vote272 views1 answer
Sql developer format sql
SQL
10 votes257 views2 answers
Reset mysql root password mac
SQL
0 vote207 views1 answer
Recover deleted data from mysql database
SQL
0 vote204 views1 answer
Dump db only triggers mysql
SQL
0 vote195 views1 answer
Mysql terminal list table
SQL
3 votes206 views2 answers
Oracle for loop
SQL
0 vote217 views1 answer
Create query in where clasue
SQL