Change Category In Interval Of Post ID’S

  • I need to change too many post categories one by one. So i thought that i can do it with mysql.
    For example i want to change category into “Books” in POST ID interval (30-40) in one timne.
    How can i do it?
    Thank you waiting for answer

Viewing 1 replies (of 1 total)

  • I’m not completely sure that I understand what you’re trying to do, but I’m taking you to mean that if your category “Books” has an id of 40, you want it now to have an id of 70.

    At your own risk (you have made a backup, right?), these steps should increase all the category ids by 30:

    UPDATE wp_categories SET cat_ID = cat_ID + 30

    UPDATE wp_post2cat SET category_id = category_id + 30

    UPDATE wp_linkcategories SET cat_id = category_id + 30

    UPDATE wp_link2cat SET category_id = category_id + 30

Viewing 1 replies (of 1 total)
  • The topic ‘Change Category In Interval Of Post ID’S’ is closed to new replies.

Tags