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

1 vote157 views1 answer
Psql view enum values
SQL
1 vote163 views2 answers
Full join
SQL
-1 vote152 views1 answer
Phinehas Psalm 106
SQL
2 votes162 views2 answers
Sql query to copy data from one column to another
SQL
2 votes142 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote144 views1 answer
How to avoid duplicate records in sqlite
SQL
4 votes153 views1 answer
Sql data types
SQL
0 vote218 views1 answer
Sql to search who modified
SQL
0 vote156 views1 answer
How to change mysql root password in windows 10
SQL
1 vote148 views2 answers
How to search date in sql query
SQL