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 vote128 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
1 vote138 views1 answer
How to select rows with no matching entry in another table?
SQL
2 votes142 views2 answers
Create empty table from existing table
SQL
1 vote130 views4 answers
Fatal database postgres does not exist
SQL
0 vote132 views1 answer
Sqlite update only if greater
SQL
0 vote139 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote144 views1 answer
How to get one year old query from plan cache
SQL
0 vote131 views1 answer
Implizite joins sql
SQL
1 vote134 views1 answer
Show indices in mysql table
SQL
0 vote131 views1 answer
Mysql set variable to today's date
SQL