How to merge/combine/transfer-entries-between two categories in the CP?

Question

I’ve got 2 categories each with lots of entries. The client wants to delete one category, and transfer it’s entries into the other one.

If I delete the category, it just disappears, but I somehow need to mass assign all those entires into another category without going through each entry manually.

Any ideas welcome.

Answer 1

This could easily be accomplished with a MySQL query on your DB. Of course, BACK UP YOUR DATABASE FIRST!

Example, assuming the old category ID is 1 and the new one is 2...

UPDATE `craft_relations` 
SET `target_id` = 2 
WHERE `field_id` = [your field id] AND `target_id` = 1;