Need to change all links in page content but not in post content

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:

  1. Manually delete post from database
  2. MySql query to get posts with all meta and terms
  3. MySQL Query to Retrieve Category from wp_posts
  4. SQL Query for getting all posts in their latest revised state
  5. Search & Remove Specific Shortcode From All Posts
  6. How to force update all posts after import
  7. Query All users that has post
  8. Can’t publish new posts
  9. Manually removing revision post types
  10. Reset/Reorder posts ID in the MySQL wp_posts table
  11. How do I find which articles are missing a featured image in The WordPress database?
  12. Tags to Post-ID mysql query. Tag Search
  13. Delete WordPress posts from URL list sql query
  14. wp_insert_post – duration
  15. Get user categories with most posts in it
  16. Custom order for Mysql array
  17. List authors with the last post title and order by last post date
  18. How to Mysql select a list of posts with meta_values AND all relevant categories?
  19. Remove a shortcode from all WordPress posts
  20. Order posts alphabetically: how to set order=asc in mysql query?
  21. What do these phpMyAdmin errors mean on my WordPress databaes?
  22. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  23. Bulk delete WordPress posts with phpMyAdmin
  24. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  25. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  26. update image path with words starting uppercase to lowercase chars
  27. Queries take 120+ seconds on my large WordPress site
  28. Database hacked – random posts are modified
  29. Can’t update WordPress Page if post_content is Empty
  30. Restore woocommerce orders
  31. How to select particular month post from table and update the post status using MySQL?
  32. How do post IDs work in WordPress?
  33. Get author posts count after excluding a category
  34. get last post’s link with SQL query
  35. How can I get posts from 9/13/11 to today with SQL? [closed]
  36. query for filtering published posts?
  37. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  38. Deleting post tags removes categories
  39. Return records between two meta datetimes saved as strings
  40. WP query taxonomy optimization
  41. MYSQL: Create SQL query to search for string and replace
  42. Query to fetch custom taxonomy along with post title
  43. Mysql update menu_order problem
  44. Bulk find & replace on WordPress posts/pages (minus image paths)
  45. WordPress MySQL Search and replace with wildcard?
  46. Add postmeta to all blog posts
  47. ‘posts’ table should not store the absolute image path
  48. Dev and prod on the same database- dev version active for IOS
  49. load post data into mysql
  50. Adding wordpress posts using phpmyadmin
  51. SQL trigger failes with post_content
  52. get backup file from wordpress database in x days
  53. Converting Posts to Pages
  54. How to change the publishing date of each posts?
  55. SQL query to remove first image in all posts
  56. Delete junk text from all the post using my sql command
  57. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  58. How to create a post based on data in a table?
  59. If meta_key exists then don’t select this post?
  60. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  61. Different post sort order within different categories
  62. How to export posts with featured image
  63. How are terms connected with posts in database?
  64. JSON not valid after json_encode posts
  65. Text after more tag in posts
  66. Hide parts of the post content on the home page
  67. Prevent post from being published if no category selected
  68. Load content in a div with ajax
  69. Direct link to “New post” in specific category?
  70. WordPress database import: Row size too large
  71. Apply a style for 4 blogs and another style for the next 4 blogs in wordpress blog page?
  72. Listing Specific Categories from Current Post with Depth
  73. Custom Post Type Rewrite To Include Parent Page(s)
  74. outputting posts’ taxonomies: cant get ‘get_the_taxonomies’ working
  75. Query for first 3 posts to change the look and feel
  76. Getting blog pagination to work on page set as front page
  77. Do one have to wait after pressing “update” on a post edit page?
  78. Add post tags to previously created custom post type
  79. Add Input Field in Simple Model Contact Form (smcf) plugin [closed]
  80. Anyone know a php snippet for showing the first 200 characters of the most recent post?
  81. Am getting duplicate data from get_posts()
  82. Pagination Not Working With Custom Post Type Category
  83. Disaply products from category
  84. Multisite Issue on Subdomain’s article pages
  85. If user has 1 post then dont let him create new one [closed]
  86. Show all posts from the tags without having to set all of them
  87. Auto populate custom fields by post date
  88. Thumbnail With Next/Prev Links Not Showing Next Post?
  89. Sort Posts Alphabetically by Multiple Categories [duplicate]
  90. How do you order posts by type then term_id and then by date?
  91. Need to show birthday of custom post type(Famous people in this case) in elementor. Date of birth set in custom fields
  92. How to monitor the first publish date?
  93. Site ‘Categories’: save an admin global setting with post metadata [closed]
  94. Exclude posts by date – related post
  95. How to get post ID after removing that post?
  96. I cannot see the pagination in /wp-admin posts page
  97. Post pages are redirecting to the 404 page in wordpress
  98. website images getting corrupt automatically
  99. Posts Page in WordPress loading bare HTML of my homepage
  100. Output number of WordPress posts remaining until a post milestone is reached