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 vote269 views1 answer
How to check oracle index table
SQL
0 vote303 views1 answer
Mysqlimport
SQL
0 vote332 views1 answer
Set Mamp mysql globally
SQL
0 vote311 views1 answer
Set mysql socket file docker windows
SQL
1 vote295 views1 answer
Python escape string for sql
SQL
3 votes313 views1 answer
Two selects in one query
SQL
0 vote317 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote330 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
6 votes336 views2 answers
How to get yesterday date in mysql
SQL
0 vote348 views3 answers
Select top 10 rows in sql
SQL