Replace serialized data

replace_serialized.sql

SET
   @search := 'https://website.com/wp-content/uploads/2019/10/the_original_image.jpg';
--COLLATE utf8mb4_unicode_520_ci;

SET
   @replace := 'https://website.com/wp-content/uploads/2019/10/the_new_image.jpg';
--COLLATE utf8mb4_unicode_520_ci;

UPDATE
   wp_postmeta
SET
   meta_value = REPLACE(
      meta_value,
      CONCAT('s:', LENGTH(@search), ':"', @search, '"'),
      CONCAT('s:', LENGTH(@replace), ':"', @replace, '"')
   )
WHERE
   meta_key = '_the_meta';