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 vote293 views1 answer
Check message id sql server
SQL
0 vote270 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote301 views1 answer
Oracle allow space to user
SQL
1 vote308 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote350 views1 answer
Mysql default port
SQL
0 vote300 views1 answer
Alter table myisam to innodb
SQL
15 votes299 views2 answers
Open postgress in terminal mac
SQL
0 vote280 views1 answer
Store query result in variable sql
SQL
0 vote296 views1 answer
IIF
SQL
0 vote329 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL