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’.
