Filter data in table using MySQL by using similar clause as INTERSECT clause

Question

By MYSQL, Filtering Products in table where Attribute_Value = "Jane Paul" AND Attribute_Value = "Diamond Publication". This type of query should show result at Book_1 as it is only product where Attribute_Value is matching. What MYSQL Query we can use for this?

What happens with the query? How is `PHP`, `MySQLi`, and `mysql-workbench` related? — user3783243, Jan 25 '22 at 14:11
Does this answer your question? [INTERSECT in MySQL](https://stackoverflow.com/questions/2300322/intersect-in-mysql) — user3783243, Jan 25 '22 at 14:13

Kathi Kellenberger · Accepted Answer · 2022-01-25T14:28:03.160

1

Try something like this

SELECT DISTINCT Product 
FROM yourTable 
WHERE Product IN (SELECT Product FROM yourTable WHERE Attribute_value = 'Jane Paul') 
    AND Product IN (SELECT Product FROM yourTable WHERE Attribute_value = 'Diamond Publication')

edited Jan 25 '22 at 14:28

answered Jan 25 '22 at 14:18

Kathi Kellenberger

104
4

Filter data in table using MySQL by using similar clause as INTERSECT clause

1 Answers1