Multiple conditional check with multiple column in same row Mysql

Question

I want to select data from the below table as per matching of two columns with multiple conditional checks.

I want to check conditions like the following.

When product_category_variants_id = 1 and product_category_variants_value_id = 2 and again product_category_variants_id = 2 and product_category_variants_value_id = 5. Then I need to get out put 8,7 and 6.

I tried the following MySQL Query to archive the above result.

SELECT DISTINCT `product_id` FROM `product_variants` WHERE (`product_category_variants_id` = 1 AND `product_category_variants_values_id` = 2) AND (`product_category_variants_id` = 2 AND `product_category_variants_values_id` = 5);

Tim Biegeleisen · Accepted Answer · 2022-09-30 11:32:36Z

1

You need an aggregation query here, as the two conditions in your WHERE clause can never simultaneously be true for any given record.

SELECT product_id
FROM product_variants
GROUP BY product_id
HAVING SUM(product_category_variants_id = 1 AND product_category_variants_values_id = 2) > 0 AND
       SUM(product_category_variants_id = 2 AND product_category_variants_values_id = 5) > 0;

answered Sep 30, 2022 at 11:32

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

Multiple conditional check with multiple column in same row 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