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 vote282 views1 answer
Alter table fulltext
SQL
0 vote275 views1 answer
Flask sqlalchemy update row
SQL
1 vote335 views2 answers
Laravel jwt generate token
SQL
0 vote310 views1 answer
Get only one row in mysql
SQL
0 vote289 views1 answer
How to reset table in sql server
SQL
0 vote276 views1 answer
Min salary in sql
SQL
0 vote287 views1 answer
Replace content value from old to new sql
SQL
1 vote270 views2 answers
Mysql order by date asc null last
SQL
0 vote274 views1 answer
Replace \n sql
SQL
0 vote284 views1 answer
In mysql workbench contnent not feching
SQL