Stuck with Mysql IN Operator

Question

I have following table given below:

id_attribute  id_product_attribute
1             1
13            1
4             2
13            2

I want to fetch id_product_attribute which have id_attribute 1 and 13.
My query is given below:

SELECT id_product_attribute 
  FROM ps_product_attribute_combination 
 WHERE id_product_attribute = 1 
   AND id_attribute IN (1,13) 
 GROUP 
    BY id_product_attribute

The above query is also returning the id_product_attribute 2 as well instead of only 1. How can I achieve this?

Can anyone please help to resolve this problem?
Thanks in Advance!

It is not possible. You may have some different data, other than you put in the question. — Shaharyar, Aug 16 '16 at 08:48
Possible duplicate of [Matching all values in IN clause](http://stackoverflow.com/questions/11636061/matching-all-values-in-in-clause) — CBroe, Aug 16 '16 at 09:24

score 1 · Answer 1 · edited May 23 '17 at 12:22

These links may help you:

Matching all values in IN clause

And

MySQL in-operator must match all values?

From the above you can then use:

SELECT id_product_attribute 
  FROM ps_product_attribute_combination 
 WHERE id_product_attribute = 1 
   AND id_attribute IN ('1','13') 
 GROUP 
    BY id_product_attribute  
    HAVING COUNT(DISTINCT ps_product_attribute_combination.id_attribute) = 2

So it will return results which are IN both id_attribute but also appear in id_attribute column specifically twice (using the Having clause).

Alternatively:

Your query states that :

SELECT id_product_attribute 
  FROM ps_product_attribute_combination 
 WHERE id_product_attribute = 1

So really you're always selecting id_product_attribute = 1. So MySQL result will always be <id_product_attribute value>

Stuck with Mysql IN Operator

1 Answers1