Search & Remove Specific Shortcode From All Posts

For the permanent solution, your SQL query is slightly off – you need:

UPDATE db1357924680.wp_posts SET post_content = REPLACE( post_content, '[print_me]', '' ) WHERE post_content LIKE '%[print_me]%'

MySQL replace example

Related Posts:

  1. MySQL Query to Retrieve Category from wp_posts
  2. SQL Query for getting all posts in their latest revised state
  3. Update all posts automatically when using post_meta
  4. Manually delete post from database
  5. Shortcode Not displayed at the Right Place [duplicate]
  6. Automatically added brs and paragraphs?
  7. Specific loop in Shortcode
  8. Query All users that has post
  9. How To Add Perfect Apostrophe And Quotation Mark In WordPress Posts?
  10. Hide Post comments when displayed via WP_Query
  11. Remove Shortcode […] from Blog Preview
  12. Manually removing revision post types
  13. Reset/Reorder posts ID in the MySQL wp_posts table
  14. UberMenu list current user’s posts as menu items
  15. Tags to Post-ID mysql query. Tag Search
  16. Query how many items to show in shortcode
  17. do_shortcode within post query
  18. How to get rid of shortcodes in post content once and for all
  19. wp_insert_post – duration
  20. get_the_content(“more…”) returns full text
  21. Is there a straight-forward way to iterate over all shortcodes in a post?
  22. How can i display gallery shortcode output under Post text
  23. How to display Common posts from specific Tag & Category with Shortcode
  24. Get user categories with most posts in it
  25. What’s the best way to render Visual Composer in posts, not pages?
  26. MySql query to get posts with all meta and terms
  27. display-posts shortcode attributes have no effect
  28. Custom order for Mysql array
  29. List authors with the last post title and order by last post date
  30. Shortcode to display the latest news article within a page
  31. How to Mysql select a list of posts with meta_values AND all relevant categories?
  32. Remove a shortcode from all WordPress posts
  33. Order posts alphabetically: how to set order=asc in mysql query?
  34. What do these phpMyAdmin errors mean on my WordPress databaes?
  35. Shortcodes on my website stops working after theme update [closed]
  36. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  37. How to get ID of the page included with get_page()?
  38. How to get a post’s details by shortcode?
  39. $wpdb returns duplicate posts
  40. update image path with words starting uppercase to lowercase chars
  41. Shortcode with ‘year’ parameter
  42. Is it possible to add a shortcode below post title?
  43. WordPress 302 Redirect to Random Product/Post/Page
  44. Queries take 120+ seconds on my large WordPress site
  45. Database hacked – random posts are modified
  46. Can’t update WordPress Page if post_content is Empty
  47. Restore woocommerce orders
  48. How to convert query sql to shortcode in wordpress?
  49. How can I add 2 buttons with shortcode
  50. Why aren’t paragraphs breaking on this page?
  51. How do post IDs work in WordPress?
  52. Get author posts count after excluding a category
  53. HTML Inside of Shortcode Breaks Shortcode Output
  54. Shortcode for tables which can include comma and linebreaks
  55. post/page content
  56. query for filtering published posts?
  57. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  58. Deleting post tags removes categories
  59. Return records between two meta datetimes saved as strings
  60. Change published date and time using SQL query for page in every 5 hour
  61. What parameters do I need to pass to get_tags to get ALL tags for the site, when used in a post
  62. get category in list of posts // shortcode for custom related posts
  63. Display “no post” message
  64. How can I create a shortcode to show the number of posts of actual day?
  65. MYSQL: Create SQL query to search for string and replace
  66. Query to fetch custom taxonomy along with post title
  67. Featured Story Shortcode not outputting content
  68. Function is printing twice – any suggestions?
  69. Mysql update menu_order problem
  70. Contact Form 7 Shortcode not recognized inside another shortcode
  71. Bulk find & replace on WordPress posts/pages (minus image paths)
  72. Add a url parameter to the current post and read it in a shortcode
  73. ‘posts’ table should not store the absolute image path
  74. Secretly passing post ID/title etc into a shortcode form automatically to link submission to post
  75. load post data into mysql
  76. I need show posts by customer (Shortcode)
  77. Is it possible to query a category with specified posts?
  78. SQL trigger failes with post_content
  79. Shortcode: How to add custom posts?
  80. Converting Posts to Pages
  81. Add category attribute to custom recent post shortcode
  82. How to change the publishing date of each posts?
  83. Shortcode for printing post titles
  84. How to use extract shortcode in loop?
  85. SQL query to remove first image in all posts
  86. Using Post ID and Page ID in same function
  87. Delete junk text from all the post using my sql command
  88. Display only posts with comments
  89. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  90. Change the default video URL in a post to shortcode format
  91. How to create a post based on data in a table?
  92. How do I add an article to specific page?
  93. get value from post to sidebar
  94. WordPress Yoast SEO plugin Post Save/Update Issue
  95. If post has non-shortcode string
  96. Insert Shortcode exactly at the end of the content
  97. Trying to create shortcode listing custom posts, but formating not being included
  98. If meta_key exists then don’t select this post?
  99. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  100. Undefined Function Fatal Error with Shortcode [closed]

Leave a Comment