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 vote296 views1 answer
What is database username and password in mysqliconnect
SQL
3 votes309 views3 answers
Create table in SQL Server
SQL
1 vote280 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote491 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote272 views1 answer
Reset postgresql password windows
SQL
0 vote298 views1 answer
Cahnge column name apex oracle
SQL
0 vote304 views1 answer
Add new column in sql with foreign key
SQL
2 votes258 views1 answer
Select * from table where name like
SQL
0 vote277 views1 answer
Oracle sql number to varchar2
SQL
0 vote305 views1 answer
Postrgesql concat 2 columns divided by ;
SQL