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 vote166 views1 answer
Mysql export and import
SQL
0 vote169 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote222 views1 answer
Create dabase postgresql
SQL
1 vote172 views1 answer
What is a Database?
SQL
2 votes171 views2 answers
Enable foreign key checks postgres
SQL
0 vote197 views2 answers
How to combine two sql queries in one result
SQL
0 vote177 views1 answer
Mysql a from on this page has
SQL
1 vote216 views1 answer
Show per page table in xampp
SQL
0 vote177 views1 answer
Sql max min
SQL
0 vote159 views1 answer
Sql right characters
SQL