Jump to content

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


Recommended Posts

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.

Link to comment
Share on other sites

  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...