MySQL server version for the right syntax to use near ''

Question

I have Mysql query problem. My query is

UPDATE oc_product p 
INNER JOIN oc_currency as c 
ON p.price2_currency_code=c.`code` 
SET p.price=CASE WHEN p.price2_currency_code='EUR' THEN p.price2*c.`value` 
WHEN p.price2_currency_code='USD' THEN p.price2*c.`value` 
ELSE p.price;

I am getting always

[Err] 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 '' at line 4

Answer 1

May be you missed the END

UPDATE oc_product p 
INNER JOIN oc_currency as c 
ON p.price2_currency_code=c.`code` 
SET p.price=CASE WHEN p.price2_currency_code='EUR' THEN p.price2*c.`value` 
WHEN p.price2_currency_code='USD' THEN p.price2*c.`value` 
ELSE p.price
END