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 votes154 views1 answer
Mysql UPDate with enner join
SQL
10 votes170 views1 answer
Oracle all_dependencies
SQL
7 votes184 views3 answers
How ot change name of column mysql
SQL
0 vote156 views3 answers
Sql select statements
SQL
0 vote190 views4 answers
User defined function sql
SQL
0 vote172 views1 answer
Where field is null sql knex
SQL
1 vote136 views1 answer
Into sql
SQL
25 votes160 views4 answers
Metadata
SQL
0 vote172 views1 answer
Sql select by content lenght
SQL
0 vote164 views1 answer
Pl sql turn off variable substitution
SQL