To use phpMyAdmin follow the steps below:
Login to phpMyAdmin panel and select your WordPress database.
Click on the SQL tab which will bring you to a page with a SQL query box.
Once you see the SQL query box, like the image shown below, you can run your SQL query there.
UPDATE wp_posts SET post_content = REPLACE (post_content, '<p style="text-align: center;"><img src="http://i.imgur.com/picture.jpg" alt="" /></p>', '');
Related Posts:
- How to make custom bulk actions work on the media/upload page?
- Custom Fields Bulk Edit
- How do I limit the status options for bulk/quick edit to only Published and Draft?
- How to hook in to bulk trash posts
- Remove all links to a specific website
- Creating bulk posts with Youtube videos
- Bulk delete users from a csv list
- how to edit title of bulk posts?
- Added new bulk action, but only work on bottom dropdown
- Modify wording of bulk options
- Bulk delete users by role? SQL?
- Renaming Custom Taxonomy Values
- wp_set_object_terms timing out?
- ex-style bulk post editing
- Bulk update status of all posts or pages on a particular path
- Create “blank” admin page without having admin-bar/admin-menu for faster load
- Custom bulk page permissions
- bulk deleting empty items in the media library
- Bulk update custom post types
- is_plugin_active function doesn’t exist
- How do I remove unwanted pages like archive, search, etc.?
- Return $post_id when DOING_AUTOSAVE?
- What is the best way to customise admin files so they survive future upgrades?
- Get author full name
- Verify nonce in REST API?
- Automatic image renaming based on title
- Unattaching images from a post
- Featured Image not showing in admin
- How to delete default themes
- wp_enqueue_scripts not called on search page?
- How to get Plugin Slugs?
- Why does `url_to_postid` return 0 when testing `page_for_posts` Page?
- Modifying Footnote Plugin for Descriptive Title Attributes
- Actions according to image type and size
- Programmatically adding posts
- How can I add a button to quicktags-toolbar?
- custom session variables being lost in FF [closed]
- How to link external JavaScript files?
- File available but giving 404 in wordpress
- Can’t delete unwanted favicon
- WordPress for a business catalog site
- For custom templates, is it better to use `template_include` or `type_template`?
- Get rewrite slug of custom post type in template
- Archive Page for Custom Post Type is not Working
- Dynamic title in WordPress homepage
- Hi, I wanted to make custom search with multiple fields
- Show titles, date of all posts on single category page
- Search widget will search everything in the site, how to limit to only search gallery name
- custom post type – page template
- Output custom field value to post string
- How to add custom control to a page?
- Navigation label for page in custom theme
- custom post template file not shown, instead all the time 404.php
- Redirect to another page using contact form 7? [closed]
- How to define custom links in WordPress
- What is the best way to modify Admin Panel on WordPress?
- Add the site’s name as prefix when adding new users? Multisite
- How do I create a root link in wordpress to a PDF file?
- Upload a web module (html and JS) to wordpress
- Customizer: get_preview_url() inside customize_save_after hook
- How to remove Customizer’s Section and move Control straight to Panel using Child Theme
- Custom Post type content within a slider
- Displaying a list of Contacts
- Woocommerce: Any way to list all products *without* a specific attribute?
- Custom css per category and per single post belong in each category
- How to publish some default pages in Multisite creation?
- Apply nextgen-gallery lightbox effect [closed]
- SQL Bulk Move old posts by one author to another category
- Display movies that apear this day next
- Delete data from custom table when deleting a post
- Custom RSS feed – blank page
- How to query term_id of a Custom Taxonomy by name
- WordPress 3.1 update has reversed my blog posts
- Different profile page by role
- WordPress menu: How to make www.link.com/#name never contain current_page_item class?
- How to show parent taxonomy using get_the_terms?
- No plugin populate user information in to form
- Best practice to generate token for email action
- how to change the url rediction of the woocommerce login page of the flatsome theme for my own in wordpress?
- My list of terms of custom taxonomy displays 7 times
- Custom Plugin: How to Include Install Buttons of other 3rd Party Plugins?
- Can’t do a src to node modules folder
- Cron job shedules replace?
- Query Posts to display all posts with category “custom field value”
- My posts page is missing the page title
- Trouble getting started in wordpress – my experience isn’t in wordpress.
- Customize a widget position
- I have tried using Plugins to remove 72K comments with no success
- How to share posts (and plugins) between existing site and new, separate dev/test installation?
- Customizer API and pages
- restrict access to specific urls on a specific period of time
- How to setup a taxonomy that can have only one post assigned to it?
- How To Customize Position of »add to cart« of WooCommerce on Product Page [closed]
- Custom Style per Post, How to Display Custom-Styled Single post on Homepage?
- Twenty Eleven theme, how to change style to a specific “format”
- custom post type single page template not working
- From a legal perspective, is it okay to customize a plugin’s code?
- Changes to code not displaying
- Has the table name in SQL for WordPress changed from WP_posts to WPCS_post?
- Multi color post title by using custom javascript inside the gutenberg editor?