Sql Query To Move Products To A Different Category By Product Name

[Amparfum]

Hi,

 

So I have a small problem. I would like to ADD one more category to certain products. I assume this works: 

UPDATE `am_category_product` SET `id_category` = 57, 78 WHERE `id_category` = 57

But I also need that from the category 57 products would be selected by name, containing specific word - like 'Giorgio Armani'. I tried adding to the query stuff like "AND pl.name = 'giorgio armani'", and so on, but it didn't work.

 

Does anyone know how to achieve this? 

Thanks in advance.

[vekia]

you have to add INNER JOIN command

FROM am_category_product cp INNER JOIN am_product_lang pl ON cp.id_product = pl.id_product

and add attional where clause:

WHERE pl.name = 'Giorgio Armani'