I tried that..but seems to be results varying somewhat.
If i try some query like this
" select property_id from property where property_id in (
select property_id from property where (name in('main','main1') AND value in ('4','4'))
select property_id from property where (name in ('p','p1') and value in ('084','072'))
select property_id from property where (name in ('second','second1')) AND (value in('5','51')))"
Is there any better option for this query?
Do this query possess any performance issue?
I tried it but it gives different results. Actually in that table
few other properties are there which have the same property_id.
Say for example:
property_id name value
12 p 1
12 hf 1
12 main 2
12 second 3
12 third 4
12 fourth 5
I think having count(*) = 2 does depend on this right?
I am not using all the properties which are having the property_id as 12.
I am using few properties to find out the property_id.
Does it matters over here?