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 vote115 views2 answers
Avg() sql
SQL
0 vote173 views2 answers
What is the default password for sql server sa
SQL
-1 vote217 views1 answer
Pl sql drop trigger
SQL
0 vote181 views1 answer
How to open mysql in docker
SQL
0 vote168 views2 answers
How to get the date from datetime in mysql
SQL
0 vote150 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote161 views1 answer
Oracle enable chain
SQL
3 votes167 views3 answers
Create table in microsoft sql server
SQL
0 vote168 views1 answer
Compression of dabatase mysqldumo
SQL
8 votes163 views1 answer
Mysql limit rows
SQL