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]%'
Related Posts:
- Stop WordPress automatically adding tags to post content
- WordPress removing tags?
- MySQL Query to Retrieve Category from wp_posts
- SQL Query for getting all posts in their latest revised state
- Update all posts automatically when using post_meta
- Manually delete post from database
- Shortcode Not displayed at the Right Place [duplicate]
- Automatically added brs and paragraphs?
- How to force update all posts after import
- Specific loop in Shortcode
- How to add shortcode tags in single.php [closed]
- Query All users that has post
- How To Add Perfect Apostrophe And Quotation Mark In WordPress Posts?
- Adding variable for post title so post template can include auto-generated link to view on external website.com/{post title}
- How to create shortcode to show the 2 latest posts
- Can’t publish new posts
- Hide Post comments when displayed via WP_Query
- Remove Shortcode […] from Blog Preview
- Manually removing revision post types
- Reset/Reorder posts ID in the MySQL wp_posts table
- Display a post by ID attribute with shortcode
- How do I find which articles are missing a featured image in The WordPress database?
- UberMenu list current user’s posts as menu items
- Tags to Post-ID mysql query. Tag Search
- Duplicating Table of Contents for Paginated Post
- Query how many items to show in shortcode
- do_shortcode within post query
- How to get rid of shortcodes in post content once and for all
- wp_insert_post – duration
- get_the_content(“more…”) returns full text
- Is there a straight-forward way to iterate over all shortcodes in a post?
- How can i display gallery shortcode output under Post text
- How to display Common posts from specific Tag & Category with Shortcode
- Get user categories with most posts in it
- What’s the best way to render Visual Composer in posts, not pages?
- MySql query to get posts with all meta and terms
- display-posts shortcode attributes have no effect
- Shortcode and whitespace formatting problem
- Custom order for Mysql array
- List authors with the last post title and order by last post date
- Shortcode to display the latest news article within a page
- How to Mysql select a list of posts with meta_values AND all relevant categories?
- Remove a shortcode from all WordPress posts
- Order posts alphabetically: how to set order=asc in mysql query?
- What do these phpMyAdmin errors mean on my WordPress databaes?
- Shortcodes on my website stops working after theme update [closed]
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- How to get ID of the page included with get_page()?
- Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
- How to get a post’s details by shortcode?
- Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
- $wpdb returns duplicate posts
- update image path with words starting uppercase to lowercase chars
- Shortcode with ‘year’ parameter
- How come a YouTube link isn’t transformed into a shortcode inside the post content?
- Is it possible to add a shortcode below post title?
- WordPress 302 Redirect to Random Product/Post/Page
- Queries take 120+ seconds on my large WordPress site
- Database hacked – random posts are modified
- Need to change all links in page content but not in post content
- Can’t update WordPress Page if post_content is Empty
- Restore woocommerce orders
- How to convert query sql to shortcode in wordpress?
- How can I add 2 buttons with shortcode
- Why aren’t paragraphs breaking on this page?
- How to select particular month post from table and update the post status using MySQL?
- How do post IDs work in WordPress?
- Get author posts count after excluding a category
- HTML Inside of Shortcode Breaks Shortcode Output
- Shortcode for tables which can include comma and linebreaks
- get last post’s link with SQL query
- post/page content
- query for filtering published posts?
- MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
- Deleting post tags removes categories
- Return records between two meta datetimes saved as strings
- WP query taxonomy optimization
- Change published date and time using SQL query for page in every 5 hour
- What parameters do I need to pass to get_tags to get ALL tags for the site, when used in a post
- Shortcode for Comments and Comment Boxes in Post Loop
- get category in list of posts // shortcode for custom related posts
- shortcode // get posts by ids
- Display “no post” message
- How can I create a shortcode to show the number of posts of actual day?
- MYSQL: Create SQL query to search for string and replace
- Query to fetch custom taxonomy along with post title
- Featured Story Shortcode not outputting content
- Function is printing twice – any suggestions?
- How to pull sticky post permalink inside php?
- Mysql update menu_order problem
- Contact Form 7 Shortcode not recognized inside another shortcode
- Display Post from Custom Post Type with Shortcode
- wp_insert_post() Add and specific ID to the body of that
- Bulk find & replace on WordPress posts/pages (minus image paths)
- Add a url parameter to the current post and read it in a shortcode
- WordPress MySQL Search and replace with wildcard?
- Add postmeta to all blog posts
- ‘posts’ table should not store the absolute image path
- Dev and prod on the same database- dev version active for IOS
- Shortcode in loop always display data of first post on the page