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 vote246 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote206 views1 answer
Get the previous column of a table in mysql
SQL
0 vote204 views1 answer
Open postgresql.conf in centos
SQL
-1 vote196 views1 answer
Mysql #1064 error
SQL
1 vote214 views1 answer
Pl sql create table from another table
SQL
0 vote220 views1 answer
Sql_inner_join
SQL
1 vote208 views2 answers
Mssql show database size
SQL
0 vote245 views1 answer
Joomla execute raw sql
SQL
0 vote193 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
9 votes241 views3 answers
Date format in sql
SQL