This is how I solved the problem in which case I wanted to change all the URLS of my target pattern to the new pattern or URL which only applied to pages and not posts. This is the sql query I ran.
update wp_posts set post_content = replace(
post_content, 'old_domain.com',
'new_domain.com') where post_type="page"
Related Posts:
- Manually delete post from database
- MySql query to get posts with all meta and terms
- How to manually delete post from database without causing conflicts?
- MySQL Query to Retrieve Category from wp_posts
- SQL Query for getting all posts in their latest revised state
- Search & Remove Specific Shortcode From All Posts
- How to force update all posts after import
- Query All users that has post
- Can’t publish new posts
- Manually removing revision post types
- Reset/Reorder posts ID in the MySQL wp_posts table
- How do I find which articles are missing a featured image in The WordPress database?
- Tags to Post-ID mysql query. Tag Search
- Delete WordPress posts from URL list sql query
- wp_insert_post – duration
- Get user categories with most posts in it
- Custom order for Mysql array
- List authors with the last post title and order by last post date
- 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?
- What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
- Bulk delete WordPress posts with phpMyAdmin
- Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
- Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
- update image path with words starting uppercase to lowercase chars
- Queries take 120+ seconds on my large WordPress site
- Database hacked – random posts are modified
- Can’t update WordPress Page if post_content is Empty
- Restore woocommerce orders
- 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
- get last post’s link with SQL query
- How can I get posts from 9/13/11 to today with SQL? [closed]
- 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
- MYSQL: Create SQL query to search for string and replace
- Query to fetch custom taxonomy along with post title
- Mysql update menu_order problem
- Bulk find & replace on WordPress posts/pages (minus image paths)
- 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
- load post data into mysql
- Adding wordpress posts using phpmyadmin
- SQL trigger failes with post_content
- get backup file from wordpress database in x days
- Converting Posts to Pages
- How to change the publishing date of each posts?
- SQL query to remove first image in all posts
- Delete junk text from all the post using my sql command
- FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
- How to create a post based on data in a table?
- If meta_key exists then don’t select this post?
- How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
- SQL phpmyadmin remove posts from cat id exclude condition
- WordPress Post Query Using Custom native MySQL like St_Distance_Sphere
- How to extract and reveal code from SQL database in WordPress
- index.php not getting blog posts anymore
- Posting to WP via URL
- How to optimize posts query in wordpress
- Custom Object Count
- Show posts from two specific category in WP_Query
- Why is WordPress showing a blank excerpt for just one of my posts?
- Is there a way to know when a page has been updated and do some action only once?
- Aligning images in the wp editor not working. How do i get this to work in custom theme?
- Updates are not showing to public (New Posts , Theme Change)
- Why sorting posts doesn’t work properly?
- Get category slug of the Parent category of a Product
- Showing Posts if non are found
- How to bulk Update URLs to new values?
- Select another post in a post meta like a parent page is selected while editing a page
- DB prefix not updating
- How to automate creating pages on a hosted wordpress from a local set of folders?
- how to Update guid = “text”+post_name?
- How can I create a shortcode to show the number of posts of actual day?
- SQL DELETE multiple post_meta on single and multi-sites
- Permalink Short code showing unnecessary link text inside the loop
- search form for custom fields
- How to put the author of the post in the comments?
- How to get tags when using publish_post
- Blog posts pagination not working
- posts_per_page is not working on my end
- Filter posts by month (dropdown)
- unable to write to the database while uploading images
- Restricting displayed posts to posts from only select authors
- Filter post by users creation date
- How to draft posts after being published with x days
- How do I change the template specifically for single posts?
- Delete all users with Editor role and their content mysql
- Change Old WordPress Post Date Year
- How to set a Post’s default visibility to ‘Private’ in Gutenberg?
- wp-insert-post execute from server?
- Sticky Post Doesn’t always work