Remove all paragraph tags

(obviously) untested, and make a backup of your DB first…but you ought to be able to do this natively in SQL:

UPDATE wp_posts
SET post_content = REPLACE(post_content, '<p>', '')
WHERE (put whatever selection logic you want here...)

Do the same for </p>. Like I said…make a backup first…

(edit) geez, didn’t realize this was a year-old question…sorry, for some reason it was edited and at the top of the active questions list…

Related Posts:

  1. How to auto-format code in Eclipse?
  2. Adding spaces in multiple lines simultaneously – in Pycharm
  3. can I add a custom format to the format option in the text panel?
  4. Change CSS/formatting on specific page, but not pages in general?
  5. How to change text size of Gutenberg editor
  6. Content over 10,000 characters won’t display with the_content()
  7. How to prevent automatic conversion of dashes to –
  8. Add dollar sign and commas to a number?
  9. Line breaks not showing up properly
  10. Use a language specific thousand separator
  11. Comment formatting with comment_content
  12. Formating the display of a post’s date, outside the Loop
  13. Formatting with
  14. How to define a custom font family for a wordpress blog that will not affect the entire site
  15. Keep formatting for tables copied from MS Word?
  16. Page formatting lost when I attempt a revision
  17. How to properly format if statement with html and php
  18. How can I prevent WordPress to wrap into a paragragraph
  19. Linebreaks behaving oddly inside blockquotes
  20. post_class() breaks out of formatting. . . extra markup also generated
  21. How to Prevent WordPress from Automatically Applying Inline Styles to Post Images?
  22. How do I format the date in Event Organizer?
  23. Images that copy code to clipboard when you click on them
  24. Formatting poetry in wordpress
  25. Trim content without stripping formatting
  26. Changing the code format for wordpress
  27. How to remove filter apostrophe and single quotation
  28. Display KML (or other “raw data” file) nicely in WP?
  29. why doesnt my formatting work in my wisiwig editor?
  30. Formatting issues within Divi theme
  31. Preparing Hardcopy and Online Page
  32. how to display the web content which contain html code prolerly?
  33. How to prevent wordpress from autoformatting my posts once and for all?
  34. How do I display page content next to a contact form, rather than under it?
  35. Multiple item layout with one query
  36. Fix issue with displaced braces( )
  37. Formatting text in posts
  38. Is there a way to reorder a collection of posts to read from top (oldest) to bottom (newest)?
  39. How to add a spoiler without using shortcode-based plugins [closed]
  40. Can’t get blog entry to format properly using wp-load
  41. Paste Function Broken
  42. How can I remove punctuation from input text in Java?
  43. Format JavaScript date as yyyy-mm-dd
  44. What does {0} mean when found in a string in C#?
  45. Double decimal formatting in Java
  46. How to print a number with commas as thousands separators in JavaScript
  47. VBA: Convert Text to Number
  48. Nice way to print_r arrays
  49. remove tags from the_content
  50. Completely strip any hidden formatting when pasting into TinyMCE
  51. Remove wptexturize from a shortcode?
  52. Problem in wordpress with “-“
  53. Place page title in header?
  54. Automatically decrease font size for long words
  55. Shortcode from a widget is wrapped in unwanted element
  56. Pasting code into pre-formatted text in Visual Editor not working in 3.3.1
  57. How to get year, month and hour in WordPress?
  58. Updating to Version 4.5 bumped my “main sidebar” widget out of place
  59. Why is WordPress WYSIWYMG and how do I make it WYSIWYG?
  60. PHP library that can merge stylesheet with inline style [closed]
  61. Why is this gutenberg custom format button only available from the toolbar as a dropdown?
  62. WordPress | Convert #038; to &
  63. How to Include HTML in Excerpts?
  64. Selectively remove empty line after line change
  65. Unautop / Sanitize content added to a post through a plugin
  66. Crafting WP_Query array, sort by date
  67. Remove add to cart icon/view product button woocommerce
  68. trigger html cleanup for all posts
  69. Posting blog entries in screenplay format
  70. Can’t format content of Rich Text Editor in Template
  71. How can I remove line breaks from manually formatted HTML?
  72. return unformatted content in encosing shortcode
  73. Space Not Being Generated in HTML Output?
  74. How to amend time format of comments, using child-theme?
  75. Multiple Rows in a using wp_query
  76. HTML tables in content areas
  77. Remove formatting in rich text with Gutenbergs Block editor
  78. Function sanitize_title() does not appear to be working
  79. Calling PHP Titles inside Javascript Markup
  80. WP Editor: Keep Bold, Underline, etc. but ignore color
  81. Using Microsift Word/Outlook for content publishing to WordPress
  82. All images on one line for each post
  83. Style wordpress image captions in RSS
  84. Email sent from WordPress has HTML tags
  85. Mystery line break
  86. get_the_term_list( get_the_ID() label formatting?
  87. Changing Date Format on Custom Meta Data w/shortcode call
  88. Object of class WP_Error could not be converted to string in /formatting.php
  89. How do I change the content of an element for a theme without losing the styling?
  90. Understanding automatic text formatting in the WordPress editor
  91. Let custom text widget use the same font as the theme
  92. Post formatting bug in WordPress
  93. Reformat data within a nested array
  94. Theme does not respect spaces between paragraphs in pages
  95. Add Default WordPress Formatting To Data From External SQL Tables?
  96. Generating a number based on post ID
  97. How to display html code normally?
  98. Show Title/Date/Excerpt of first post & only Title for rest in Query [duplicate]
  99. How to show only text from post in WordPress
  100. Adding padding above menu