nested if in mysql

Solutions on MaxInterview for nested if in mysql by the best coders in the world

showing results for - "nested if in mysql"

1SELECT CASE col1
2	WHEN 'agree' THEN 'Ok'
3    ELSE
4        CASE 
5            WHEN col2 >= 1 THEN 'Ko'
6            ELSE 'Maybe'
7        END
8END AS my_result
9FROM table_name;

similar questions

select with condition query in mysql in condition in mysql mysql if without else mysql return if it contains mysql get nested records mysql case when multiple conditions sql nested if statement in select if in mysql mysql if multiple conditions mysql use if on select mysql select field if condition mysql execute query if condition mysql if statement mysql if statement in where clause nested case statement in mysql

queries leading to this page

how to write nested if statement in mysql nested if in mysql query nested if in mysql nested if else mysql nested if in mysql