Auto delete posts based on content text

If you’re comfortable using phpMyAdmin, you can run this query:

DELETE FROM wp_posts WHERE post_content LIKE "%A line of same text that should be deleted%"

Replace with the text you’re wanting to remove, but keep the “% %” symbols. The percent symbols mean to search for that string anywhere inside the post content – even if there’s a bunch of other content before and after it.

If you have special characters in the line of text, you may need to escape them.

As with any query, make sure you have a current, working backup before you run this query. 🙂

Related Posts:

  1. How to display by default only published posts/pages in the admin area?
  2. Find out who deleted a page or post?
  3. Post/Page Preview Template
  4. using wp_update_post on save_post
  5. Custom permalink structure only for default posts
  6. Replace image attributes for lazyload plugin (data-src)
  7. WordPress plugin to publish to multiple remote WordPress blogs
  8. Any way to create a revision of a post ONLY with a new button in the Meta Box?
  9. How to display comments and comment form on custom post type?
  10. How to wrap every image in a post with a div?
  11. Show One Category on Post
  12. WordPress Delete hook with wp_delete_post function?
  13. Custom post type single (permalink) throws a 404 error
  14. Order post by year DESC and month ASC
  15. Do I use custom post type or something else?
  16. how “manage_posts_custom_column” action hook relate to “manage_${post_type}_columns” filter hook?
  17. display order of connections
  18. Delete Post From Front-End and attachment permanently
  19. if custom post type exist
  20. How to get a nofication when post submitted
  21. Custom post type permalinks breaking due to 3.1 bug fix
  22. ‘Invalid post type’ error when importing from one site to another
  23. Blogroll – Different layout for first post
  24. How to delete old posts’ edits to save space?
  25. Get post id in wordpress action?
  26. Display page content AFTER a loop of posts
  27. How can I create custom button in post.php
  28. how to replace embedded “full” sized images within a post with the “large” ones
  29. Downgrade user from role that allows post creation
  30. Remove slashes (both before and after) in relative post url
  31. Edit custom post type admin menu link
  32. How to include a post type in the admin/backend?
  33. How to make number of blog posts a custom field?
  34. WordPress blog or WordPress website
  35. Using custom post template
  36. Hiding Draft Post In Admin
  37. Adding custom fields to bbpress reply form
  38. WordPress custom Query for Posts in Category display posts multiple times
  39. Making a custom Pagination for multi page blog post
  40. Permission issue with custom post type – not added to menu – by plugin
  41. Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
  42. Add a custom meta box in the post options that loads some html code in the header
  43. Static posts page with home.php
  44. Thumbnail & Category link aside post
  45. Is it possible to customize the post according to post format in single.php?
  46. Is there a way to create a meta box that can be added multiple times to a post dynamically?
  47. WordPress custom post type with folder structure in slug
  48. Using setup_postdata() with multi-dimensional array
  49. How to add automatically bootstrap 4 order-lg-1 and order-lg-2 classes for columns in foreach loop based on the count?
  50. Show custom post with custom categories with specific slug
  51. Display the 2nd category name of a custom post type without error if its null?
  52. Querying another post category to match current post and display in loop
  53. datepicker value in mysql
  54. Simple Custom Metabox Not Saving
  55. How to restore deleted post related with deleted users
  56. Delete post from admin but not from database
  57. Custom Post Type Single Loop Outputting Wrong Post
  58. Organization of time insensitive content
  59. Custom Select Query – Selecting the Year?
  60. How to output all taxonomy links from a custom post type in a menu?
  61. Can I style single post that are in multiple catergories?
  62. WordPress Post Deletion Issue
  63. How Can I Always Display A Particular Post First Using WP_Query?
  64. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  65. Change modified date to current date when title updated automatically
  66. How to put the author of the post in the comments?
  67. How to add a custom class attribute into code wrapper? [duplicate]
  68. Redirecting wordpress search query to archive page
  69. How to create custom search form function including post “tags”
  70. How to invoke a HTML custom button based on a HTML dropdownlist menu
  71. Please I want to prefix my WP posts title according to each category
  72. insert post fails after multiple postings
  73. Manual Scheduler For Custom Post Type
  74. Custom Post Type Rewrite URL
  75. Dev and prod on the same database- dev version active for IOS
  76. Custom Post Types and Broken Permalinks
  77. The first post appears twice
  78. How to delete/customize imported demo content from a theme or add my own?
  79. Customizing URL slugs of Custom Post Type and Taxonomy make posts/pages 404
  80. Append a random string to a post permalink
  81. single- and archive- templates not being applied to custom post types, not even after flushing permalinks
  82. Show Posts By Custom Field
  83. Custom Post Type doesn’t use single.php or single-{custom_post_type}.php
  84. How to retrieve custom field values and save again as array
  85. Is there a Standard Format for Clean URLs for Archives of Custom Posts?
  86. How can I have the posts from one word press blog show on the presentation page of another word press site
  87. Customize search results to include custom posts and display in a specific template page
  88. Custom permalink based on custom post type fields
  89. Checking if some condition is matched before inserting post into database
  90. How to only allow post to be deleted if custom field doesn’t exist
  91. Show a Category Specific Info Box
  92. Custom Post Title as search term
  93. adding custom meta as well as looping through posts
  94. Best way to enable sorting by 3 criteria on a page of listings
  95. How to show only the date, the title and a little “summary” of my WordPress post in my custom theme?
  96. How remove “recent comments” title without modifying code? [closed]
  97. How edit footer copyright info? [closed]
  98. Notify/check if the content of a custom gutenberg block has changed on save_post
  99. WordPress Custom Post type csv exporter
  100. Edit Page button is gone