mysql case when multiple conditions

SELECT CASE col1
	WHEN 'agree' THEN 'Ok'
	WHEN 'disagree' THEN 'Ko'
    ELSE
        CASE 
            WHEN col2 >= 1 THEN 'Ko'
            ELSE 'Maybe'
        END
END AS my_result
FROM table_name;

5
1
Lionel Aguero 33605 points

                                    select (
case when (value1 = 1) then (value2)
when (value2 = 1) then (value1) end) as newColumnname  
from tablename where value1 = 1 or value2 = 1

5 (1 Votes)
0
Are there any code examples left?
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
where condition with multiple values in sql multiple conditions when sql multiple conditions in case when sql mysql multiple case when t sql nested case in select multiple when in case sql how to write two conditions in case statement in sql sql case multiple as sql multiple where conditions multiple where conditions in mysql switch case with select in sql server switch case in sql server case statement with two conditions sql sql statement with multiple where conditions sql case statement with multiple conditions case query in mysql select statement inside a case statement mysql oracle sql case with multiple conditions sql case with multiple conditions mysql condition with multiple conditions mysql where case when mysql case when into case when HOW TO USE CASE WHEN IN NESTED CONDITIONS IN SQL how to multiple conditions in sql mysql multiple case mysql case statement multiple conditions to check mysql case statement multiple conditions nested select case sql sql statement where multiple conditions case for where mysql case when with multiple conditions sql in multiple conditions sql multiple case switch sql sql multiple case when multiple if statements in mysql trigger multiple if condition in mysql how to check two conditions in if statement in mysql how to use multiple case when in mysql case when with multiple conditions mysql case then els in mysql two case when in mysql multiple mysql condition case in sql server sql multiple and in where clause in one query sql server case 2 conditions sql if statement multiple conditions CASE WHEN in mysql query where clause with multiple and in sql case when mysql case statement multiple conditions and sql case statement multiple conditions sql mysql select case example sql multiple conditions switch case sql sql case multiple when oracle sql case when multiple conditions multiple where clause in sql case in mysql query case statement for mysql query where clause with multiple and conditions sql select nested and case oracle case statement multiple expressions oracle case statement with multiple columns oracle case statement multiple columns selecting where condition with multiple values sql multiple case sql sql where clause multiple values in sql where condition have multiple rows multiple conditions in ON sql case with multiple else in sql multiple conditions in where clause sql using multiple where clause in sql sql case when example multiple sql where multiple values clause sql nested if statement oracle sql case statement with multiple conditions where multiple conditions sql multiple or in where clause sql sql server switch case sql case multiple conditions sql function using switch case nested if else in sql sql where clause multiple conditions where clause with multiple conditions mysql multiple if conditions sql case multiple statements in then mysql use case when without select where sql multiple conditions mysql where 2 conditions switch case sql server example multiple conditions case count sql multiple condition in sql where clause update query with multiple case statement in sql with where condition multiple where condition in query case when sql server multiple conditions case when multiple or conditions sql multiple case statements where with multiple conditions in sql sql nested if how use multiple condition in if in sql how to have multiple when condition in sql how to use multiple if condition in sql query multiple case statements sql oracle case when multiple conditions sql case when 2 conditions multiple where conditions sql sql case when multiple sql multiple case when select inside a case statement mysql multiple where condition in mysql sql case when multiple and case with multiple conditions in sql case statement in sql server multiple where condition in sql mysql where clause multiple or conditions mysql case on where multiple if mysql case sql server sql when multiple conditions mysql case in select mysql case in where clause mysql write select in case statement switch sql server case when multiple conditions sql case when multiple conditions case when sql server case sql server when case mysql example sql case multiple then WHen case mysql can we write case statement in where clause in mysql where clause sql with multiple values where clause in sql with multiple values sql nested case when case when sql multiple conditions where clause in sql with multiple conditions sql query where in multiple conditions sql query where multiple conditions mysql case My SQL case when mysql query case when only using one case when in mysql sql if else where multiple value sql where multiple conditions multiple case in sql server case mysql multiple case when sql mysql case when or multi condition if in sp mysql sql statement with several conditions sql switch case example sql switch case statement sql switch case switch case sql server mysql switch case in select mysql case then case statement with multiple conditions in oracle case statement with multiple conditions in mysql mysql case two conditions mysql if multiple conditions multiple if condition in sql select query sql nested if statement in select sql if statement in where clause multiple values sql case statement in where clause multiple values case statement with multiple conditions in sql server sql case when multiple values pl/sql case when multiple values case statement in where clause oracle with multiple conditions case statement in oracle with multiple conditions examples nested case statement in sql nested case statement in mysql mysql select case when mysql case when mysql case when query mysql case when multiple mysql case when in select sql case when multiple then sql case when multiple conditions mysql select where multiple conditions mysql multiple when case mysql multiple case conditions and sub case statement multiple case in where clause mysql multiple condition in case statement + mysql case when multiple AND mysql when and mysql multiple and conditions case when multiple conditions mysql mysql select case when multiple conditions case with multiple conditions in mysql case mysql multiple conditions within when case when in mysql with multiple conditions CASE WHEN multiple conditions in mysql mysql update case multiple conditions multiple condition with or in mysql case how to querry based on multiple conditions in mysql mysql multiple conditions mysql multiple case conditions mysql case two conditions same value mysql multiple and conditions mysql case 2 conditions case when many conditions mysql mysql case with multiple conditions mysql multiple where conditions mysql where multiple conditions multiple conditions in mysql mysql select case multiple conditions mysql where with multiple conditions mysql where two conditions mysql case when multiple conditions in one mysql conditional set case multiple mysql multiple case statements mysql case with multiple condition case mysql multiple conditions sql when multiple conditions mysql count case when mysql multiple conditions mysql case when multiple conditions
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source