Edit post_content on posts with Featured Image

I would do this as follows:

  1. Back up the entire DB (or certainly the wp_posts table!)
  2. Run this query to get all posts that have a featured image:
    SELECT wp_posts.* FROM wp_postmeta INNER JOIN wp_posts ON (wp_postmeta.post_id = wp_posts.ID) AND meta_key=’_thumbnail_id’;
  3. Export the results to a plain SQL file with SQL inserts
  4. Do your search and replace within that SQL file
  5. Reimport the data.

This assumes your tables have the default prefix obviously.

Related Posts:

  1. Querying terms with calculations based on term meta data, sql vs. get_terms
  2. meta_query for user ID in array
  3. Merge meta_value’s into a single row and then loop
  4. How to do a meta query using REST-API in WordPress 4.7+?
  5. Meta query terribly slow
  6. meta_query sorting by 2 keys
  7. How to handle optional end date in compare clause in meta_query
  8. Using meta_query on pre_get_posts to exclude a particular meta_key value
  9. Add custom fields to search
  10. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  11. Best practice – Meta Query vs. post_clauses for “left join” ordering
  12. Different page parameters inside query
  13. meta_query key value from array
  14. LIKE %…% Meta Query
  15. Order by nested named meta queries with ‘exists’ and ‘not exists’
  16. Documentation for post meta
  17. Arrange Posts By Date In Order Of Closest To The Current Date
  18. Custom Upcoming Events List for Events Manager Plugin
  19. How to use meta_query to check if a meta field has something set?
  20. Advanced WP Query hogs the SQL server
  21. User Relationship
  22. How to make a WP REST API query with meta_query in WP4.7?
  23. List of posts by day of the week
  24. Use both meta query and tax query
  25. meta_query, number comparison, not quite working as it should
  26. Query posts only if meta_value is not empty
  27. How to pass user meta_key and meta_value (values as array)
  28. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  29. meta_query compare=’!=’ with multiple custom fields
  30. Query posts with numeric meta values within a given range
  31. Optional Meta Query
  32. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  33. meta_query not working on live site
  34. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  35. Meta query with regular expression does not work
  36. Changing sort order for presentation by Jetpack infinite scroll
  37. Archive post by meta value + 24hours
  38. WP User Query Issues
  39. How to use meta query for greater than value in array?
  40. Meta Query And/Or
  41. Filter posts by meta query?
  42. Help on multiple meta_query
  43. Meta query – How to display a null meta key
  44. pre_get_posts and set
  45. How to use orderby with meta_query?
  46. Orderby doesn’t work like expected on custom query
  47. last_name + first_name orderby with meta_query [solved]
  48. Extend meta query arguments
  49. get_posts( $args ) return empty data
  50. how to get post meta where value is an array of key value pairs
  51. WP_Query: apply an SQL function to meta fileld value
  52. Meta Query Based on Month Range
  53. how to search all user meta data that have value like “vivek”
  54. Find posts by related taxonomy field
  55. wordpress meta value compare between two date
  56. Can I use pre_get_posts to add up values from two different meta_keys?
  57. WP JSON API meta_query not working
  58. Sorting posts by ACF field
  59. Ordering custom posts by meta field date
  60. latitude/longitude meta_query
  61. meta_query displays all results and none, my query is wrong
  62. How to properly escape values in meta query
  63. Delete all posts with a specific custom field using meta_query
  64. Fetch custom post related to a User
  65. How to Ordering by user meta
  66. Use meta_query in args for relationship
  67. meta_query Array
  68. meta_query compare “=“ returns nothing when it seems it should
  69. Order resultset by configured value and then list all the rest
  70. Issue with user meta_query
  71. How to get an archive page meta?
  72. Search for value(s) in meta field for a multi select
  73. WP Query – grouping posts by same meta key, adding together values from another key
  74. How can I create a meta_query with an array of dates?
  75. WordPress meta query not working
  76. Get meta_value from GDRating
  77. Why does this incorrect pre_get_posts meta_query work for sort order?
  78. How to sort custom posts including null meta-values ​in admin columns with meta_query?
  79. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  80. meta_query not filering but meta_key works fine
  81. get posts meta query returning the latest post if no meta key found
  82. WordPress search between two newmeric values with a custom post type
  83. WP User Query with meta queries
  84. Search using specific meta fields only (excluding post title and content)
  85. How to fetch WP_User_Query with multiple role arguments [duplicate]
  86. How to get meta value based on latest post id with group by term name
  87. Meta query not returning results even though the sql contains the information
  88. Display Users from two roles in one list
  89. WP_Query with UNIX timestamp in meta query
  90. Multiple Queries with meta_query
  91. Get foreach for meta_query value
  92. Meta query “OR” comparison not working as expected with array
  93. WP_Query with several meta_query-statements and order by meta_value
  94. order by meta_key [duplicate]
  95. WordPress Meta Query very slow with NOT EXISTS comparison
  96. ACF meta_query field treated as “0” resulting in false negative search when testing ranges
  97. Is it possible to customize meta query in this way?
  98. Ordering WP_Query results by second meta_key
  99. How making a new search box in admin post table working on a specific column
  100. wp_user_query with meta_value_num for leaderboard