[MySQL] CASE albo IF w WHERE Opcje

[Elber]

Witam,

mam problem z zapytaniem z CASE bądź IF w WHERE (IMG:style_emoticons/default/smile.gif)

Mam zapytanie:

[SQL] pobierz, plaintext 
SELECT
	c.*, s.name AS sname,
	p.name AS pname
FROM
	certificate c LEFT JOIN 
	products p ON c.products_id = p.products_id LEFT JOIN 
	STATUS s ON c.status_id = s.status_id
WHERE
 
	p.name LIKE "%"
AND
	c.filename LIKE "%" 
AND
	c.status_id LIKE "%"
 
ORDER BY
	c.certificate_id
DESC
[SQL] pobierz, plaintext 

Które działa jeśli c.products_id > 0 a gdy jest = 0 to tego rekordu nie wyświetla co jest logiczne ( bo szukam tak że po nazwie produtku (p.name)).

Pytanie jak to obejść ? Żeby rekordy z c.products_id również wyświetlał ?

Próbuję:

[SQL] pobierz, plaintext 
SELECT
	c.*, s.name AS sname,
	p.name AS pname
FROM
	certificate c LEFT JOIN 
	products p ON c.products_id = p.products_id LEFT JOIN 
	STATUS s ON c.status_id = s.status_id
WHERE
 
	CASE WHEN c.products_id > 0 THEN p.name LIKE "%" ELSE NULL END
AND
	c.filename LIKE "%" 
AND
	c.status_id LIKE "%"
 
ORDER BY
	c.certificate_id
DESC
[SQL] pobierz, plaintext 

Jednak wyświetla tylko te z c.products_id > 0 (IMG:style_emoticons/default/sad.gif)

Ten post edytował Elber 26.02.2013, 23:56:58

[CuteOne]

[SQL] pobierz, plaintext 
IF (c.product_id > 0,  p.name LIKE '%%')
[SQL] pobierz, plaintext 

[Elber]

[SQL] pobierz, plaintext 
SELECT
	c.*, s.name AS sname,
	p.name AS pname
FROM
	certificate c LEFT JOIN 
	products p ON c.products_id = p.products_id LEFT JOIN 
	STATUS s ON c.status_id = s.status_id
WHERE
	IF(c.products_id > 0, p.name LIKE "%")
AND
	c.filename LIKE "%" 
AND
	c.status_id LIKE "%"
 
ORDER BY
	c.certificate_id
DESC
[SQL] pobierz, plaintext 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND c.filename LIKE "%" AND c.status_id LIKE "%" ORDER BY c.certificate_' at line 9

[CuteOne]

IF(c.products_id > 0, p.name LIKE "%",1)

[Elber]

Działa (IMG:style_emoticons/default/smile.gif) Kombinowałem już wczoraj z IF ale zamiast 1 końcu dawałem NULL albo 0 (IMG:style_emoticons/default/biggrin.gif) jakoś mnie tak przyćmiło, a teraz jak napisałem z 1 to mnie oświeciło (IMG:style_emoticons/default/smile.gif) Dzięki zapomoc (IMG:style_emoticons/default/smile.gif)