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 vote337 views1 answer
Max length found in mysql
SQL
0 vote345 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote338 views2 answers
Find nth highest salary of an employee
SQL
0 vote426 views2 answers
Sqlalchemy default value for column
SQL
0 vote334 views1 answer
Postgres populate table from another table
SQL
0 vote322 views1 answer
MySQL - How to find word with the most similar beginning
SQL
2 votes345 views1 answer
Sql as
SQL
0 vote312 views1 answer
Can we rollback deleted data in sql
SQL
1 vote351 views1 answer
What is in condition in sql
SQL
0 vote382 views3 answers
Postgres trim string
SQL