Citat:
Originalno napisao webarto
Please 
1.
PHP kôd:
SELECT * FROM resource_attributes
WHERE
(attribute_value LIKE '%La%' AND attribute_id = 6) [b]AND[/b]
(attribute_value LIKE '%Ho%' AND attribute_id = 8)
GROUP BY resource_id
|
Ovo tvoje može da radi, bez višestrukih JOIN-a, baš sa OR, ali da izdvojiš samo one zapise koji imaju obadva uslova zadovoljena.
Kôd:
SELECT *, COUNT(*) as broj_atributa FROM resource_attributes
WHERE
(attribute_value LIKE '%La%' AND attribute_id = 6)
OR
(attribute_value LIKE '%Ho%' AND attribute_id = 8)
GROUP BY resource_id
HAVING broj_atributa = 2