Thread: SQL Help - Moving items en masse from one category to another

We have many categories on our website that have approx. 50 items in them. We would like to move them to new categories in the fastest way possible - that's not accomplished by changing where each item is mapped to on an individual basis.

Is it possible to write a SQL query that move all items (for example) category 200 to category 300?

If that's possible to do, how would something like that be written?

Thank you.

HTML Code:

UPDATE ProductCategory SET CategoryID = 300 WHERE CategoryID = 200;

TTFN

BFG

Thank you - that's big time saver!