Change featured image urls in database

The featured image is stored in the *_postmeta table under the _thumbnail_id key. In fact, chances are that you’ve got a lot of image/media urls in that table, which you haven’t changed. The problem is that a number of things are stored in serialized arrays and changing them with SQL as above will (probably) break those arrays. I would suggest using something like Velvet Blues Update Urls.

It looks like you have changed all of your URLs and not just the image/media URLs. Is that what you intended?

Also, you should never change the guid.

NOTE and EDIT: I just noticed an exception for attachment media in the WordPress Codex. I don’t remember ever seeing that and I am not sure what that is about and I am not sure what to make of that at the moment.

Related Posts:

  1. Get Featured Image via direct sql query
  2. How to Remove Two (Related) wp_postmeta Rows?
  3. How to delete posts that does not have a thumbnail?
  4. Cleaning up bloated wp_postmeta table by removing multiple _thumbnail_id’s?
  5. Query to delete all featured images and remove post meta?
  6. Get post featured image id with $wpdb
  7. Remove Featured Image based on Date
  8. MySQL swap one table for another?
  9. Copy wp_postmeta from one database to another
  10. Add class name to post thumbnail
  11. Delete original image – keep thumbnail?
  12. the_post_thumbnail responsive srcset not populating with custom image size
  13. Set custom name for generated thumbnails
  14. How to add multiple image sizes of the same size with add_image_size
  15. change set_post_thumbnail_size according to post type admin page
  16. Can’t extract and set SVG dimensions
  17. Getting Thumbnail Path rather than Image Tag
  18. How to crop thumbnail height to auto with set width
  19. Image uploader with “Set Featured Image” link on front end
  20. adding an id to the_post_thumbnail
  21. How can I display my featured image correctly inside my single posts?
  22. Featured image upload finished hook
  23. Generate thumbnail for images with the same size as thumbnails
  24. Implementing Zurb’s Interchange Into WordPress
  25. How to get_posts having post thumbnail?
  26. Display the first image from a post in RSS feed
  27. Filter For Featured Image
  28. add_image_size and add_filter(‘image_size_names_choose’, ‘my_custom_image_sizes’) not working with wordpress 3.5.2
  29. Custom post type thumbnail / Media Library WP_DEBUG notice [closed]
  30. Add body class based on existance of post thumbnail. Code works but receiving PHP Notice
  31. Delete all thumbnails for a post
  32. How to display thumbnail + tags + title of a child page?
  33. Archive Thumbnail Gallery
  34. WordPress Uploader Editor shows broken image
  35. How do i show wordpress attachments from current post?
  36. How to get full absolute url for post attachment?
  37. Is there a way to change a post’s thumbnail image(s)?
  38. WordPress thumbnail settings change
  39. Using concatenate with WordPress Thumbnail
  40. Looking for Add Title Tag on Feature Images on WP
  41. Is it possible to nest get_previous_post()?
  42. Notice: Trying to get property of non-object when trying to get thumbnail URL
  43. Output post thumbnail (add class)
  44. How to set an equal image size for a Fallback Image as used for the Featured Image(dynamicly)
  45. How can I see where in my themes and plugins certain image sizes are used?
  46. How do I remove featured images and captions from a wordpress RSS feed?
  47. Custom image size in the_content loop
  48. Display featured image file size, extension, filename, type, orientation?
  49. Video playing from featured image?
  50. get_the_post_thumbnail(‘thumbnail-name’) always returns empty string
  51. array set title and alt in the_post_thumbnail
  52. Get thumbnail image according to the screen
  53. Displaying Post Featured Images on All Pages
  54. Image Alignment on Featured Images
  55. Trying to show link “Use as featured image” from Attachment window from t31os script
  56. Use Featured Image of Post as Header Image
  57. Recent posts on homepage: different thumbnail based on logged in status and post category
  58. How to display featured image description and title?
  59. Images uploaded on frontend display correctly but not in media editor.
  60. get_post_thumbnail does not display thumbnail
  61. Make image full width
  62. Facebook Does Not Grab Correct og:Image
  63. WordPress 4.4 responsive sometimes doesn’t work
  64. get_the_post_thumbnail($post->ID, ‘thumbnail’); not working. How can I solve this?
  65. Is it possible to add the_post_thumbnail to style.css?
  66. Getting featured image of particular size.
  67. Different thumbnails for index and article page
  68. Smaller thumbnail in the_content
  69. Attachment Image using wrong src?
  70. Unable to set Custom “Link URL” for Featured Image, and More?
  71. On what point (hook) does the_/has_post_thumbnail() load?
  72. First Image not loading on Mobile Version of Website
  73. Thumbnails not being generated for PDF files
  74. Make 1st Slide of PowerPoint file to be the Post thumbnail preview image
  75. Is it possible to set Featured Image using HTML?
  76. Set featured image from auto generated video thumbnail url php
  77. Use Post Title as alt text for Featured Image
  78. How to cropped thumbnail image without distorting it?
  79. WordPress default srcset with hard crop
  80. wp_get_attachment_metadata()[‘image_meta’] fetch WP metadata or EXIF?
  81. White Blank screen and issue to get thumbnail in
  82. Set Featured Image Based on Custom Field
  83. Post thumbnail on specific template
  84. Using lower resolution/size images for thumbnails on posts index
  85. How to have featured image show in standard RSS Widget
  86. Link from Thumbnail to Post not working
  87. Featured Image metabox (postimagediv) doesn’t appears when it should
  88. Thumbnails not showing in blog
  89. Featured Image inserted through custom query, does not show up
  90. How to import linked images and make them featured -> automagically
  91. Change role’s settings influence post-thumbnail
  92. Wrap Featured Image in a Link
  93. Thumbnail images
  94. Featured Image Thumbnail Sizing
  95. Featured Image Isn’t showing with cropped, How to show it?
  96. How to modify Media Library images DPI [ image quality down to make small in size ] [closed]
  97. How to add text & call to action button to featured image on homepage?
  98. Featured image as background in a div using headway
  99. php code for image fetching
  100. Strange image artifact on font-page thumbnail image