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 votes131 views1 answer
Update with join sql server
SQL
2 votes151 views2 answers
Install sqlalchemy
SQL
0 vote146 views1 answer
Select row with latest date mysql
SQL
0 vote140 views1 answer
Sql tabelle erstellen
SQL
0 vote135 views1 answer
List all permissions on a table in postgres
SQL
0 vote130 views1 answer
Sql server inner join convert collation
SQL
0 vote178 views5 answers
Select concat alter table mysql
SQL
0 vote101 views1 answer
Update set with join pl sql
SQL
0 vote97 views1 answer
Print sum of values sql
SQL
0 vote198 views3 answers
How to find all role in mysql
SQL