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 vote272 views1 answer
Mysql select row with min date
SQL
0 vote281 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote259 views1 answer
Select all domains of database firbird
SQL
1 vote290 views1 answer
Oracle check table space
SQL
0 vote288 views1 answer
Get last updated row sql server
SQL
0 vote301 views1 answer
Sql join on a subquery
SQL
0 vote285 views2 answers
Drop check constraint in ms sql
SQL
0 vote251 views1 answer
Get last run query sql server
SQL
1 vote300 views1 answer
Blob datatype in mysql
SQL
0 vote303 views1 answer
Sql order by except one row
SQL