I spend a couple of hours to figure this out, but my SQL is quite poor
I have to update about 300 products in my products table. Those products belong to certain categories which are defined in another table called products_to_categories.
My query should look something like this:
UPDATE products SET products_tax_class_id = 0 WHERE products_id = x
... where x are all products belonging to a certain category.
Is there something like an UPDATE ... SELECT command in MySQL or can I put a JOIN in my WHERE condition in order to filter only those products belonging to a certain category?
Any help would be really appreciated