If-else in where condition - MySQL

Question

I've data ike this

PX01 , Dony, ASUS , Area1

PX01 , Dony, ACER , Area1

PX01 , Dony, SONY , Area1

PX02 , ROKY, ASUS , Area2

PX03 , Steve, ASUS , Area1

I want select data IF(Area2) Just Asus, but if(Area1) Asus and SONY. How to write if else in the where part of my query.

Sample

SELECT 
    .....  
WHERE if(Area = 'Area1') { PRODUCT = ASUS AND SONY} 
IF(Area = 'Area2' ) { PRODUCT = ASUS }  
IF(Area = 'Area3' ) { PRODUCT = SONY }

Please include the exact output you are expecting here.

Tim Biegeleisen
– Tim Biegeleisen

2020-11-12 04:47:04 +00:00
Commented Nov 12, 2020 at 4:47 — Tim Biegeleisen
– Tim Biegeleisen, Commented Nov 12, 2020 at 4:47

Akina · Accepted Answer · 2020-11-12 04:50:30Z

1

SELECT {columns list}
FROM {table name}
WHERE CASE Area WHEN 'Area1' THEN Product IN ('ASUS', 'SONY')
                WHEN 'Area2' THEN Product = 'ASUS'
                WHEN 'Area3' THEN Product = 'SONY'
                             ELSE NULL
                             END;

answered Nov 12, 2020 at 4:50

Akina

43.2k6 gold badges17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

If-else in where condition - MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related