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 vote207 views4 answers
Get week day from date in sql
SQL
0 vote238 views1 answer
Sql cheetsheet
SQL
0 vote193 views1 answer
Postgres sql alter table delete row
SQL
0 vote224 views1 answer
Show tables in cassandra cql
SQL
0 vote238 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
17 votes322 views4 answers
Show all tables in oracle
SQL
0 vote194 views1 answer
Java mysql swing example
SQL
0 vote150 views1 answer
Delete all rows from table sqlite
SQL
10 votes180 views4 answers
Join with multiple conditions sql
SQL
2 votes168 views1 answer
Oracle current date without time
SQL