Multiple where condition in sql query

Question

This is my table structure.

I want to compare the column property_id by the column label_id.

Table: label_master

id	label_id	property_id	property_value
1	1	1	10
2	1	2	15
3	2	1	20
4	2	2	25
5	3	1	5
6	3	2	10

I want to apply the condition like

where (property_id = 1 and property_value >= 10) and (property_id = 2 and property_value >= 15)

I want to check both property_id's property_value of same label.

My expected out is

id	label_id	property_id	property_value
1	1	1	10
2	1	2	15
3	2	1	20
4	2	2	25

score 2 · Answer 1 · answered Sep 08 '21 at 15:46

2

You want or in your logic:

where (property_id = 1 and property_value >= 10) or
      (property_id = 2 and property_value >= 15)

answered Sep 08 '21 at 15:46

Gordon Linoff

I want only those who satisfy both conditions. – Dhruv Raval Sep 08 '21 at 15:48
@DhruvRaval MySQL checks these conditions for **each row**. A single row cannot have both a value of `1` _and_ a value of `2` at the same time, it's one _or_ the other. – gen_Eric Sep 08 '21 at 15:50
Can we use join? – Dhruv Raval Sep 08 '21 at 15:52
@DhruvRaval Did you even try this suggestion? It gives you the output you wanted in the question: http://sqlfiddle.com/#!9/0536ee/6 I don't see why you'd need a `JOIN` here. – gen_Eric Sep 08 '21 at 15:53
Not working as expected. Check http://sqlfiddle.com/#!9/fca3614/1 – Dhruv Raval Sep 08 '21 at 16:01
It must satisfy both constion – Dhruv Raval Sep 08 '21 at 16:02
@DhruvRaval You changed `id = 5` to have a `property_value` of 15, instead of 5. – gen_Eric Sep 08 '21 at 17:24

1 Answers1