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 vote228 views1 answer
Mysql terminal list table
SQL
0 vote246 views1 answer
Insert ip address in mysql
SQL
10 votes229 views3 answers
Join multiple tables sql
SQL
3 votes220 views1 answer
Sql datetime as date
SQL
1 vote254 views1 answer
Sqlalchemy on delete set null
SQL
0 vote242 views1 answer
Insert data from stored procedure into table
SQL
2 votes225 views1 answer
Oracle drop table free up space
SQL
0 vote263 views1 answer
C# sql transaction multiple connections
SQL
0 vote228 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote246 views3 answers
Duplicate row mysql
SQL