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. Moving formatted data in Salesforce rich text field into WordPress
  43. Expected RBRACE, but the bracket is there?
  44. std::string formatting like sprintf
  45. Convert java.util.Date to String
  46. How to format numbers as currency strings
  47. Properly formatted multiplication table
  48. How to format a string as a telephone number in C#
  49. (Excel) Conditional Formatting based on Adjacent Cell Value
  50. Formatting Code Snippets on Free WordPress.com Account?
  51. Issue with enabling formatting in excerpts in WordPress
  52. Remove hidden formatting when user paste text from MS Word into TinyMCE
  53. Preserve white-space in Page
  54. Formatting post content to exclude gallery
  55. Why does WP not like my container?
  56. Add visual editor capability to custom excerpt window?
  57. Lost formatting after saving
  58. Keep pasted pre formatted code as it is -with tabs- in visual editor
  59. Is there a way to disable formatting shortcuts in 4.3?
  60. Get last seen date/time in wordpress get_comments() [closed]
  61. $content = $post->post_content; with formating
  62. How to center oEmbedded content
  63. What are the “U” and “G” time formats?
  64. Unwanted line break before
  65. Number format for wp_count_posts()
  66. Modify Gallery Output to render differently on a PAGE and a POST
  67. Is sanitize_title_with_dashes formatting function too liberal (in terms of accepted characters)?
  68. How to set up VS Code for WP plugin/theme development in 2021? [closed]
  69. How to preserve exact formatting when copy pasting from Facebook into WordPress (or elsewhere)?
  70. How can I remove line breaks from manually formatted HTML?
  71. How can I add custom text styles to the visual text editor?
  72. Exclude uploaded files from appearing in the excerpt()
  73. Space Not Being Generated in HTML Output?
  74. WordPress get_the_content losing formatting when emailed
  75. Multiple Rows in a using wp_query
  76. Special Formatting for WordPress Plugin Description?
  77. HTML tables in content areas
  78. Displaying Meta-Box Data Properly
  79. Using Microsift Word/Outlook for content publishing to WordPress
  80. Pasting formatted text from MS-Word
  81. All images on one line for each post
  82. Problem with -> in pre tags
  83. Snippet to Format Elementor Text Box Throws Error
  84. Email sent from WordPress has HTML tags
  85. Measure time in ONLY HOUR format
  86. Is there an easy way to remove the data-preserver-spaces span from blocks?
  87. Page takes on two different formats
  88. Understanding automatic text formatting in the WordPress editor
  89. Paste from word not preserving formatting
  90. How to format the various types of custom fields?
  91. What could interfere with changing iframe contents with href?
  92. the_content inside my own theme does not retain line breaks / enters like in the admin
  93. ACF loop and php formatting
  94. WordPress excerpt with formatting and allowing selected tags
  95. getpost content with all formatting for admin pages
  96. Add Default WordPress Formatting To Data From External SQL Tables?
  97. Custom formatting
  98. Date is showing in unreadable format. How to convert to readable date?
  99. How can I add the option to format to list in RichTextToolbarButton?
  100. How to customize Date Format for American visitors?