Update product descriptions of a specific category

[siomosp]

Hi

i am looking for a sql query for updating all products of a specific category and language

something like that

 

 

UPDATE ps_product_lang

SET description_short='<h3>test</h3>'

WHERE ps_category_product.id_category = '5'

AND ps_product_lang.id_lang=2

 

 

Any help?

[i2imedia]

Have you tried calling the table names first and then giving them a alias? I called the tables a and b.

 

UPDATE ps_product_lang a, ps_category_product b

SET description_short='<h3>test</h3>'

WHERE b.id_category = '5'

AND a.id_lang=2