Deleting All tags except categories Wp database

delete from `wp_terms` where `term_id` in ( SELECT `term_id`
    FROM `wp_term_taxonomy`
    WHERE `taxonomy` = 'post_tag' ) and `term_id` not like 1

The above Code was exactly what I was looking for.

Related Posts:

  1. Custom SQL Query: Get all posts with category id and a concated list of tags on each post
  2. How to store category and tags separatly on wordpress?
  3. Is There a Difference Between Taxonomies and Categories?
  4. What is the difference between a “tag” and a “category”?
  5. Control term order on a per-post basis
  6. get all tags from category
  7. 404 Error On Category and Tags Pages
  8. Checklist of selected categories
  9. How to tax query X number of posts related by tag first, then by category if not enough in tag-related
  10. Category and tag with same name
  11. In the tag archive – display count of posts for each category they belong to
  12. Automated adding of one tag to all the posts in a category
  13. How to convert regular categories to custom taxonomy?
  14. Moving Categories submenu to Media, but still opens Posts menu
  15. Exclude most recent posts from specific category in wp_query()
  16. When using get_categories or similar, is it possible to filter results that contain certain Tags as well?
  17. Script to duplicate categories as tags
  18. Search by word, category, tag, author
  19. How to filter archives both by category and tag?
  20. display most popular tags of category?
  21. Get tags specific category
  22. Can paginate_links() be customized for a specific category or tag?
  23. Category archive page – loop through posts of certain tag (with pagination) – pre_get_posts
  24. Category vs Tag vs Table
  25. Custom WP_Query for current category (in category.php)?
  26. How to find the number of Tags a post has?
  27. How to not treat categories as tags in feeds
  28. Are Category or Tag Archive Pages Possible?
  29. How can I duplicate categories and tags?
  30. Random post + categories + tags
  31. Search Posts / Pages with multiple options?
  32. Display tags from specific category in select fields
  33. Offline WordPress Application
  34. Find out which user created a category or tag?
  35. RSS/XML of all Categories and/or Tags
  36. Get Tags specific to Category using WooCommerce plugin
  37. Modify WordPress SQL Query to pull from within a category
  38. How to make 2 tag feeds show up on 1 page?
  39. Different templates for different category tags
  40. Get link which associated with a specific category and tag
  41. batch adding posts to a category based on matching regex for title with SQL
  42. How to get related tags based on a category?
  43. Needing a snippet for listing category specific tags
  44. How to list categories within tags?
  45. How to “group” (categorize) the Pages together?
  46. Is There a Difference Between Taxonomies and Categories?
  47. Use Tag input metabox style for Categories
  48. menu using category and tags
  49. limit a list of tags to one category [closed]
  50. Have multiple category queries from the URL been fixed yet?
  51. Wacky taxonomy in wordpress
  52. Related Tags not in category
  53. Is there a reason I cannot get the current category in a loop?
  54. Array: What is this value based on?
  55. Show the amount of posts in a tag in a specific category has
  56. Display all product tags associated with a specific product category
  57. How replace individual elements in the RSS feed with a single string
  58. Adding a H1 Tag to Post Tags automatically, but hide the tag? (Same for Category)
  59. Delete all posts that do NOT have a specific tag
  60. Deleting a category from WordPress admin does it remove it completely from the database?
  61. Tags Instead of Category
  62. Conditional category & tag statement
  63. Include either name or slug in the include parameter using wp_list_categories?
  64. How can I filter posts by tag on the fly
  65. Filter categories/tags to display in multiple metaboxes for selection in back-end
  66. Editing Loop So It Targets Specific Tags?
  67. How can I include custom category and tag base in template files?
  68. Pretty URLs with Categories and Tags
  69. Autolinking keywords in text with tags
  70. Maintaining a separate posts page for certain categories and don’t show those on home page
  71. Are tags different than categories?
  72. Custom menu with categories and tags
  73. Show Posts via cat+cat in URL that are in both Categories doesn’t work
  74. Display all categories but only if they have posts in them that have a specific tag assigned
  75. Help to display the current categories and tags of a post
  76. Hide specific category tag on single post page
  77. Filtering posts in category by tag URL
  78. echo $category[0]-> cat_name; shows only one category name
  79. How to show entries related to main category
  80. When creating category, it creates automatically tag, or, when creating tag, it creates automatically category in same name
  81. Using heirarchial tags or Custom taxonomies
  82. Get category from slug list
  83. Search Replace Database ONLY for posts of certain category?
  84. Re-coding category-template.php to go to custom URL
  85. Category and tag urls return 404 error
  86. How to echo Tags and Categories as plain text
  87. Tag Menu items based on their categories
  88. Hide category name using mod_rewrite
  89. How to exclude category and post_tag taxonomy while displaying custom taxonomy?
  90. 404 error when i try to search by category or by tag
  91. How to remove specific categories from tag archives？
  92. A simple question regarding tags and categories
  93. Display related posts with same category or same tag return blank
  94. htaccess redirect for all categories converted to tags now showing 404
  95. Loops in category description
  96. How to create a category or tag available exclusively to the admins and not to the users?
  97. altering theme – content generated by PAGES not PORTFOLIO
  98. Search tag within category
  99. List products from current category
  100. add an image field to wordpress category