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 vote126 views1 answer
Flask sqlalchemy decimal
SQL
65 votes293 views6 answers
Sql add column to table
SQL
1 vote122 views2 answers
Mysql spring boot application.properties
SQL
1 vote79 views1 answer
Athena query timestamp greater than
SQL
0 vote163 views1 answer
Select milliseconds mysql
SQL
0 vote125 views1 answer
Sqlite referential integrity
SQL
0 vote81 views1 answer
Mysql date + 1 day
SQL
-1 vote124 views3 answers
Create temp table in sql
SQL
0 vote134 views1 answer
Query only first letter string
SQL
0 vote151 views1 answer
SQL check if record exist
SQL