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

2 votes350 views1 answer
Oracle run_duration average
SQL
0 vote352 views1 answer
Php mysqli install
SQL
0 vote407 views1 answer
Hierarchal database table
SQL
0 vote399 views1 answer
Finding leap year in sql
SQL
0 vote353 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote337 views1 answer
How to connect postgresql database with java
SQL
1 vote349 views1 answer
Mysql return text after a final full stop
SQL
8 votes291 views8 answers
Second highest salary in mysql
SQL
4 votes285 views1 answer
Oracle sleep
SQL
-1 vote336 views1 answer
Search all database tables for a value sqlserver
SQL