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 vote345 views1 answer
Sql query row number group by
SQL
0 vote361 views1 answer
Xampp increame mysql speed
SQL
0 vote353 views1 answer
Cast for print sql
SQL
0 vote359 views1 answer
Mysql undo delete
SQL
0 vote376 views1 answer
Stored procedures example
SQL
15 votes366 views4 answers
Export mysql db using command line
SQL
0 vote350 views1 answer
Docker open terminal mysql server
SQL
0 vote361 views1 answer
Power bi find all ids not in other tables
SQL
1 vote331 views1 answer
Select statement to print longest name
SQL
1 vote357 views1 answer
Oracle schema size
SQL