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 vote176 views1 answer
Django how to get query result count
SQL
0 vote192 views1 answer
How get data from database if id not found then search another column
SQL
0 vote179 views1 answer
Sql period overlap
SQL
1 vote187 views1 answer
Rows to comma separated values in mssql
SQL
10 votes191 views4 answers
How to alter table name in mysql
SQL
1 vote188 views2 answers
Extract weekday from date in sql
SQL
2 votes198 views2 answers
Mysql add hours to time field
SQL
1 vote192 views1 answer
How to unlock table in mysql
SQL
5 votes207 views4 answers
SQL Order of execution
SQL
0 vote196 views1 answer
Mysql grouping functions
SQL