Add VAT to all Products (Apart from one Category)

[limelites]

We've just registered for VAT so we need to add VAT to all products, site wide, apart from a sepcific category.

I have an SQL query that's switch it on across the board:

UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0; 

How would I exclude category 350 from this query? Would really appreciate any help here.

[davowave]

I'm not so hot on SQL but if you use easy-populate then you could do it easily with that. Most ppl seem to have easy-populate installed :)

[Ajeh]

If that is the master_categories_id on the Products you can use:

UPDATE products set products_tax_class_id = 1 where products_tax_class_id = 0 and master_categories_id != 350;