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 vote266 views1 answer
Postgres list all stored procedures query
SQL
9 votes249 views2 answers
Mysql change value
SQL
3 votes281 views1 answer
Laravel paginate raw sql
SQL
2 votes252 views2 answers
How to rename column name in sql server using query
SQL
49 votes284 views6 answers
Alter table add column
SQL
1 vote259 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote262 views1 answer
Sql first day quarter
SQL
3 votes248 views2 answers
Oracle apex charging debug
SQL
0 vote271 views1 answer
How do you insert boolean to postgresql
SQL
0 vote258 views1 answer
Mysql utc timestamp
SQL