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

6 votes193 views3 answers
Mysql remove user privileges
SQL
1 vote187 views1 answer
Raise application error in oracle
SQL
0 vote189 views3 answers
Sql query checker
SQL
4 votes181 views2 answers
Oracle default date format
SQL
0 vote191 views1 answer
Write sql query to show the details start from digit
SQL
1 vote178 views1 answer
Sql auto date
SQL
0 vote190 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
3 votes185 views1 answer
Oracle list privileges
SQL
0 vote174 views1 answer
Is not null postgresql
SQL
0 vote178 views1 answer
How to put is null in where in clause
SQL