How Do I Merge Categories With phpMyAdmin

You can’t simply “merge categories” you have to change the category that each post is associated with. The table WP_TERM_RELATIONSHIPS links posts with categories. You could try something like this:

UPDATE wp_term_relationships 
SET term_taxonomy_id = 
   (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 112748)
WHERE term_taxonomy_id =
   (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 112747)

You might also try this plugin: http://wordpress.org/plugins/batchmove/

Related Posts:

  1. How Do I Delete WordPress Posts Older Than 400 Days, From A WordPress Category
  2. Custom Query to search through categories
  3. Disallow categories from this MySQL query
  4. Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#
  5. How to get related tags based on a category?
  6. How to list all categories and their IDs using SQL query?
  7. how to get postmeta info based on multiple categories?
  8. How to create a foreign key in phpmyadmin
  9. importing a CSV into phpmyadmin
  10. How To Find Out WordPress Category Table in MYSQL?
  11. is_category() in pre_get_posts strange error
  12. Rearranging posts based on categories
  13. How to convert regular categories to custom taxonomy?
  14. How to query all posts of a specific category, and any other category combination
  15. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  16. Query the Loop without breaking it
  17. How to Check if a Child Category is Being Queried
  18. Delete all post meta except featured image
  19. Deleting All tags except categories Wp database
  20. WooCommerce – Query for ordered products
  21. How to find if a post with custom_field == X exists?
  22. WP database error for comments_popup_link()
  23. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  24. Query WordPress database by registered date and role
  25. Set Display Name to first and last name (phpmyadmin SQL Query)
  26. Emojis getting converted to “?”
  27. Category archive page – loop through posts of certain tag (with pagination) – pre_get_posts
  28. Is it good practice to use wpdb->query() function?
  29. If newest post of category is newest post in general, skip first post of category
  30. Select Multiple meta_value from WP DB; Single Query
  31. Delete all post meta except featured image Using SQL
  32. Update slug (URL) of pending posts via phpMyAdmin
  33. CRUD operations using WordPress database API
  34. How to display posts under a specific subcategory of a given category
  35. get_the_category and echo out link to child-most/deepest category
  36. Change the category of all posts in it
  37. How to run select query of post with category and tags for API?
  38. query in category.php repeats itself
  39. Display posts separated by Category in Author’s page
  40. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  41. Category param redirect to post type archive
  42. How to get latest posts from each category in regular order
  43. category pagination got broken suddenly
  44. Better ads plugin has 500.000 entries in wp_postmeta
  45. How to query categories with Advanced Custom Fields?
  46. Where and when does WordPress invoke routes
  47. Can Categories be used to hack a Multisite-like setup w/ a single MySql db?
  48. Wacky taxonomy in wordpress
  49. Query multiple tables at once?
  50. Changing root password in PHPMyAdmin for WordPress Database when going live
  51. Can’t update WordFence Options, clear data manually
  52. Custom WordPress Table wpdb
  53. Best practice to limit results in get_row()?
  54. Exclude category from query
  55. Array: What is this value based on?
  56. Overriding default calendar to show posts from a category
  57. Always get creating a new table with foreign key
  58. SQL query to set posts in bulk based on the post content
  59. Query Column of Specific ID from Database Table
  60. function query_posts disabling current_page_menu class
  61. Files on Localhost, Database on Server
  62. Deleting a category from WordPress admin does it remove it completely from the database?
  63. custom query for both category and pages using global $wpdb;
  64. Query from multiple category (and)
  65. How to display posts from specific category using get_option function?
  66. WordPress: Using the category slug get the category ID using mysql query
  67. How to add categories using mysql
  68. SQL error with custom query
  69. How to filter post from categories only if the posts appears in one of them, not the other?
  70. Show Posts via cat+cat in URL that are in both Categories doesn’t work
  71. DB prefix not updating
  72. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  73. Deleted products from woocommerce are still in the database
  74. Create categories manually in database
  75. Store GravityForm data in phpmyadmin (mysql)
  76. How do I merge WooCommerce categories with the same name?
  77. Get category from slug list
  78. Search Replace Database ONLY for posts of certain category?
  79. Issue with WordPress category search
  80. Querying posts from two different categories while looping inside another loop
  81. Missing latest posts and options after DB migration via phpMyAdmin
  82. Too many categories drastically slow down my website
  83. How to get posts from many categories using WP_Query
  84. Get category fixed in dropdown browse categories
  85. WP_Query always returning the last custom post
  86. Check if a database is well installed
  87. Is it possible to query the result of a query?
  88. show posts found in multiple categories via category_name query string?
  89. Backend – Categories and Menus conflicts
  90. Category slug in in loop always the same?
  91. display certain category on custom template page
  92. Detecting top parent category fails on home page
  93. How to use Greek characters/letters in a query?
  94. Displaying posts by year
  95. wordpress category.php query for featured news item, broken pagination and repeating posts
  96. finding out the top 5 source ( source is a custom taxonomy ), in a given category
  97. add an image field to wordpress category
  98. How to show posts of a specific category
  99. Fetch all categories from database
  100. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta