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 vote351 views1 answer
How to add unique key constraint in mysql
SQL
12 votes337 views1 answer
Docker run mysql image
SQL
0 vote323 views1 answer
Oracle sql date summer time
SQL
6 votes397 views2 answers
How to get last element sql
SQL
0 vote369 views1 answer
SQL Query to delete all the tables in a database
SQL
1 vote343 views1 answer
Postgres select as csv
SQL
2 votes350 views4 answers
Mysql select into new table
SQL
1 vote352 views2 answers
Sql left characters
SQL
0 vote367 views1 answer
Load data from text file to mysql database on mac terminal
SQL
0 vote302 views1 answer
Sql new line output
SQL