mySQL to change parent categories

See if this thread helps.

Indeed that will help once I add in an exclude parameter! I’ll post my query here when I’m done. Thank you gain vtxyzzy!

@vtxyzzy Thanks for the link above. I used that and then figured out how to add some logic to only target categories in the taxonomy and how to exclude specific categories from being modified. Excluding a category from being modified prevents a category from becoming it’s own parent. It will still execute correctly and WordPress will load, but you will not get a list of categories, because it’s illogical.

UPDATE wp_term_taxonomy
SET parent = 1115
WHERE taxonomy='category' AND term_id != 1115

In the example above I’ve used 1115 as my category I want to exclude from the statement, which can be modified to target any category ID as well as multiple categories.

I hope this helps others as well.

Thanks for the feedback. Now, please use the dropdown at top right to mark this topic ‘Reaolved’.