filter by multiple attributes
Posted
by cosy
on Stack Overflow
See other posts from Stack Overflow
or by cosy
Published on 2010-04-22T13:58:46Z
Indexed on
2010/05/10
18:04 UTC
Read the original article
Hit count: 247
I have the table :
id id_products id_atribut name value
1 13 8 autdio 2.1
2 13 9 hdd 200 Gb
3 13 10 cd-rom 2
4 20 8 audio 2.1
the problem is, how can i select from this table where name="audio"
and value="2.1"
and name="hdd"
and value="200 gb"
and return id_products=13
....
How can i do this?
© Stack Overflow or respective owner