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 vote213 views2 answers
Restart identity cascade
SQL
3 votes237 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote233 views1 answer
Oracle 11g forget password
SQL
0 vote219 views1 answer
Replace string in whole database mysql stackoverflow
SQL
2 votes201 views1 answer
Convert series number to date in sql
SQL
6 votes224 views6 answers
Count mysql
SQL
1 vote175 views1 answer
Full text index mysql
SQL
0 vote229 views1 answer
To_date sql
SQL
7 votes209 views1 answer
Safe mode mysql
SQL
0 vote215 views1 answer
Varchar format not case sensitive sql
SQL