Specify Key value when Search and Replace in Sterilized Data.

[adampatterson]

I came across the scenario of moving my S3 bucket and while doing that also changed the path.

I upload an image, It is sent to Kraken.io, and Uploaded to S3 using Media Offload.

I made a copy locally of the database and ran wp search-replace 'old-bucket 'new-bucket. To my joy, the serialized string was also updated.

My next task was to update the media path. Previously it would have been old-bucket/year/month

Now it would be new-bucket/media/year/month

If I were to search and replace based off of /2015 I am going to affect the _wp_attached_file and _wp_attachment_metadata

Is it possible to search inside of two columns where one column value is equal to something else?

Like look in meta_value where meta_key == amazonS3_info?