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 vote297 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote267 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
0 vote278 views1 answer
Mysql Like(searching in the string)
SQL
0 vote260 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote267 views1 answer
Sql drop default
SQL
1 vote292 views1 answer
Mysql alter decimal precision
SQL
0 vote279 views2 answers
How to get last inserted id in sql server c#
SQL
7 votes284 views3 answers
Foreign key oracle
SQL
0 vote269 views4 answers
Sql year
SQL
0 vote287 views1 answer
Multiple like values for single column postgres
SQL