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 vote103 views1 answer
Difference between 2 query results sql server
SQL
25 votes116 views6 answers
Import database mysql command line
SQL
0 vote102 views2 answers
Many to many flask-sqlalchemy
SQL
2 votes100 views1 answer
Drop sequence
SQL
6 votes122 views4 answers
Mysql group by date
SQL
4 votes109 views1 answer
Mysql ip address data type
SQL
8 votes100 views2 answers
Sqlsrv default port
SQL
1 vote93 views4 answers
Between vs in sql
SQL
1 vote99 views2 answers
Sql server backup table
SQL
13 votes100 views2 answers
Sqlite rename column
SQL