batch adding posts to a category based on matching regex for title with SQL

figured it out. I spent literally days trying different code and the answer was under my nose. Lack of sleep!

replace “INSERT” with “REPLACE”

any tips for removing a category?

Related Posts:

  1. Deleting All tags except categories Wp database
  2. Modify WordPress SQL Query to pull from within a category
  3. SQL to migrate post types to taxonomy
  4. Custom SQL Query: Get all posts with category id and a concated list of tags on each post
  5. Get posts under a category with SQL
  6. Get a count of how many times a term or a category is used in posts
  7. SQL query to return categories and category parents
  8. Overriding default calendar to show posts from a category
  9. SQL query to get posts from multiple categories but not in a category
  10. Assign a list of categories with a parent category
  11. Get category from slug list
  12. Bulk Change WordPress category Slug
  13. Help with SQL query, how to add taxonomie terms with value stored in options?
  14. finding out the top 5 source ( source is a custom taxonomy ), in a given category
  15. How to create an automatic MultiColoumn MegaMenu with Categories WordPress
  16. Is There a Difference Between Taxonomies and Categories?
  17. List all subcategories from category
  18. How To Find Out WordPress Category Table in MYSQL?
  19. Add custom field to Category
  20. Get Category ID inside Category template
  21. Only one category per post
  22. WordPress Multisite – global categories
  23. Get the children of the parent category
  24. Get posts from sites in Multisite?
  25. WP REST API: filter by category 1 AND category 2
  26. How To Get Parent Category Slug of Current Post
  27. Display All Products by Category with WooCommerce
  28. What is the difference between a “tag” and a “category”?
  29. Is there an easy way to make a meta box have the tabs like the Categories meta box has?
  30. How to check if I’m on the last page of posts?
  31. Display posts from the same category using next/previous post link
  32. How would I get a taxonomy/category list inside a Gutenberg block?
  33. Can I set a default featured image for a category?
  34. Check if a post is in any child category of a parent category
  35. How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
  36. Force category choice before creating new post?
  37. Gutenberg editor add a custom category as wrapper for custom blocks
  38. WooCommerce: List All Categories
  39. How to get category and archive title?
  40. Get category ID from category slug (not working)
  41. How do I remove “Uncategorized” from posts with more than 1 category?
  42. Get rid of WordPress category, tag and author archives?
  43. Individual rss feed entry length for categories?
  44. How can I create a category landing page followed by pages of posts?
  45. Remove parent category from permalink? Basically only have the child category?
  46. Custom permalink structure leads to be 404 on pagination
  47. Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
  48. Posts URL structure like site.com/category/the-post-title
  49. Can’t custom taxonomies have same terms (slugs) as categories?
  50. How to get permalinks with category base working with sub-categories
  51. How to remove the term “category” from category pagination?
  52. Using wp_category_checklist in a widget
  53. WP 3.9 TinyMCE no longer loads on category description editor
  54. On the category page, get the category object
  55. Get only the top level categories using get_categories() without foreach loop
  56. Get all categories and posts in those categories
  57. How to add featured image for category (without a plugin)?
  58. How to create a custom sort for WordPress categories
  59. How to display non-hierarchical taxonomy as terms with checkboxes?
  60. Category archive by year with permalink support /category/YYYY
  61. Best Way to Redirect Category to Page and Hide Category
  62. get_terms vs. get_categories: does it matter?
  63. What is a good robots.txt?
  64. Allow users to create their own feed from selected categories?
  65. Hook when category is added to post
  66. get_categories for custom post type with a specific custom taxonomy attached
  67. Add a URL prefix to permalinks of one category of posts only
  68. How do you add categories to custom post types in WordPress?
  69. Create a category list page
  70. Catch 404 after changing permalink structure from /%postname%/ to /%category%/%postname%/
  71. Woocommerce get category image full size
  72. exclude category from get_posts?
  73. How To Modify The Loop in archives.php To Have 11 Posts Per Page and CSS Styling
  74. How can I hide a category from Contributors in the edit/add new post screen?
  75. Order get_terms() By Custom Field
  76. WordPress Multiple Category Search
  77. Should category.php and The Loop be used if the query needs to be customizable?
  78. How do the ‘tag’ and ‘category’ (default) taxonomies do ‘save_post’ action?
  79. How to Change the Categories Order in the Admin Dashboard?
  80. Control term order on a per-post basis
  81. How to remove categories filter from wordpress admin?
  82. get all tags from category
  83. Could not insert term into the database
  84. How can I add the featured image functionality to a custom taxonomy?
  85. Activate Gutenberg in category-descriptions
  86. Filter by post category in Media Library
  87. Filtering categories in the permalink structure
  88. Share one taxonomy across multiple blogs in 3.0 [duplicate]
  89. 404 Error On Category and Tags Pages
  90. How to show subcategories in categories else show posts
  91. Allow duplicate permalink slugs for posts in different categories
  92. Exclude the category from the WordPress loop
  93. get_categories hierarchical order like wp_list_categories – with name, slug & link to edit cat
  94. How to make child categories recognize parent’s template displays
  95. Force WordPress to Show Pages Instead of Category
  96. Completely disable categories
  97. How do I get the category URL from get_the_category?
  98. Display Image for a category using get_categories, or show an image from any child post
  99. Remove / Rename Uncategorized Category In WordPress
  100. Fixing category count
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)