switching product xml package

[MMJ]

Hi:

Is there is a sql statement to switch from a certain product xml package to another package?
Any feedback is appreciated.

regards,

[BFG 9000]

Something like this :-

UPDATE Product SET XmlPackage = 'new.product.xml.config'; 

to update them all, or...

UPDATE Product SET XmlPackage = 'new.product.xml.config' WHERE ProductID = 123; 

to update a specific product, or...

UPDATE Product SET XmlPackage = 'new.product.xml.config' WHERE ProductID IN (SELECT ProductID FROM ProductCategory WHERE CategoryID = 89); 

to update all products in a specific category, or...

UPDATE Product SET XmlPackage = 'new.product.xml.config' WHERE XmlPackage = 'old.product.xml.config'; 

to update only products that use old.product.xml.config.


TTFN

BFG