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 vote164 views1 answer
Possgress drop if exists view
SQL
1 vote305 views1 answer
Sql check roles
SQL
4 votes174 views3 answers
Employee name starting with in sql
SQL
0 vote190 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote197 views1 answer
Set root password mysql xampp
SQL
0 vote153 views1 answer
Drop all tables in azure sql database
SQL
0 vote182 views1 answer
Sql delimiter to columns
SQL
0 vote158 views1 answer
How to Remove milliseconds from Date time
SQL
29 votes194 views6 answers
Delete all rows from table mysql
SQL
1 vote278 views1 answer
Oracle current sequence value
SQL