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. How to manually delete post from database without causing conflicts?
  4. MySQL Query to Retrieve Category from wp_posts
  5. SQL Query for getting all posts in their latest revised state
  6. Search & Remove Specific Shortcode From All Posts
  7. How to force update all posts after import
  8. Query All users that has post
  9. Can’t publish new posts
  10. Manually removing revision post types
  11. Reset/Reorder posts ID in the MySQL wp_posts table
  12. How do I find which articles are missing a featured image in The WordPress database?
  13. Tags to Post-ID mysql query. Tag Search
  14. Delete WordPress posts from URL list sql query
  15. wp_insert_post – duration
  16. Get user categories with most posts in it
  17. Custom order for Mysql array
  18. List authors with the last post title and order by last post date
  19. How to Mysql select a list of posts with meta_values AND all relevant categories?
  20. Remove a shortcode from all WordPress posts
  21. Order posts alphabetically: how to set order=asc in mysql query?
  22. What do these phpMyAdmin errors mean on my WordPress databaes?
  23. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  24. Bulk delete WordPress posts with phpMyAdmin
  25. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  26. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  27. update image path with words starting uppercase to lowercase chars
  28. Queries take 120+ seconds on my large WordPress site
  29. Database hacked – random posts are modified
  30. Can’t update WordPress Page if post_content is Empty
  31. Restore woocommerce orders
  32. How to select particular month post from table and update the post status using MySQL?
  33. How do post IDs work in WordPress?
  34. Get author posts count after excluding a category
  35. get last post’s link with SQL query
  36. How can I get posts from 9/13/11 to today with SQL? [closed]
  37. query for filtering published posts?
  38. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  39. Deleting post tags removes categories
  40. Return records between two meta datetimes saved as strings
  41. WP query taxonomy optimization
  42. MYSQL: Create SQL query to search for string and replace
  43. Query to fetch custom taxonomy along with post title
  44. Mysql update menu_order problem
  45. Bulk find & replace on WordPress posts/pages (minus image paths)
  46. WordPress MySQL Search and replace with wildcard?
  47. Add postmeta to all blog posts
  48. ‘posts’ table should not store the absolute image path
  49. Dev and prod on the same database- dev version active for IOS
  50. load post data into mysql
  51. Adding wordpress posts using phpmyadmin
  52. SQL trigger failes with post_content
  53. get backup file from wordpress database in x days
  54. Converting Posts to Pages
  55. How to change the publishing date of each posts?
  56. SQL query to remove first image in all posts
  57. Delete junk text from all the post using my sql command
  58. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  59. How to create a post based on data in a table?
  60. If meta_key exists then don’t select this post?
  61. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  62. SQL phpmyadmin remove posts from cat id exclude condition
  63. Get WordPress post content by post id
  64. Get page ID of page that is set as the posts page
  65. Display Random Author with Details in Sidebar
  66. Get old values for post before saving new ones
  67. order posts by date like craigslist
  68. What to use: wp_is_post_autosave( $post_id ) or DOING_AUTOSAVE?
  69. How to sort posts by last name (2nd word) on ONE category only?
  70. Why do I need to use The Loop on pages (inside page.php etc)?
  71. How to get previous 10 days post from a specific date – WP Query
  72. Automatically added brs and paragraphs?
  73. Automatically create pages in a post based on number of words
  74. Divide Post content into separate divs for every 500 characters (or any other character counts)
  75. Delete Post Link to delete post, its meta and attachments
  76. Change default screen option value for posts per page
  77. post_exists() in an external script?
  78. prevent showing posts of an specific category in admin posts section
  79. Repost post on specific date every year
  80. How to get Advanced Custom Field Value According using POST ID? [closed]
  81. New blog template to display only one category
  82. wp_insert_post question [closed]
  83. Show the author’s count of total amount of posts assign to a custom taxonomy term
  84. publish_post conflicts with save_post
  85. post_date vs. post_modified – what’s the difference? [closed]
  86. Invalid post type when click “Filter” or “Apply” button in WordPress admin Post list [closed]
  87. Adding a cancel button to edit post screen
  88. Disable Jquery UI post tabs
  89. Dynamically generate child-URLs for posts or custom posts
  90. If Specific Post, Link Elsewhere
  91. What structure should post_content have in the database?
  92. Can’t Delete or find a blog post (unknown)
  93. Format the Layout of Images In The Edit Post Textarea?
  94. Choose whether to automatically add a taxonomy with the same name as the post
  95. Which WordPress hook fires after post content loaded?
  96. Enable Comments Box On Custom Post Type
  97. Get Posts Under Custom Taxonomy
  98. Integrate OpenStreetMap on WordPress
  99. how do i add posts-page slug before posts slug in permalinks
  100. Admin – create custom post status and display above table