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

1 vote199 views1 answer
Sql pick random row
SQL
3 votes198 views1 answer
Get all elements sql
SQL
0 vote194 views1 answer
Inner joint
SQL
24 votes194 views5 answers
Sql reset auto increment
SQL
4 votes202 views1 answer
Conda install sqlalchemy
SQL
0 vote218 views1 answer
Mysql value ends with
SQL
14 votes204 views2 answers
Install mysqldump
SQL
1 vote212 views1 answer
Sql server update column based on another table
SQL
1 vote181 views1 answer
Real world example of nosql
SQL
16 votes201 views3 answers
Jwt secret key generator laravel
SQL