DB search and replace not effective on attachments data

Attachments actually stores data as JSON, do you happen to know if WP_CLI’s search/replace also tends to JSON formatted postmeta?

Now there’s a question. A quick Google turns up these…

https://github.com/interconnectit/Search-Replace-DB/pull/62 (this is the WP-CLI plugin for DB search and replace) is titled “Added support for replacing cells serialized via json/encode64”

https://pantheon.io/blog/wordpress-quick-tip-search-and-replace-wp-cli says “and WP-CLI knows how to unpack JSON payloads stored in your DB, perform the search and replace on them, and then if changed, re-pack them and update the database”

The WP CLI docs for search and replace (https://wp-cli.org/commands/search-replace/) state “It will correctly handle serialized values, and will not change primary key values.”

I don’t know enough (yet) about how JSON gets stored to tell whether these references imply that S&R should succeed or not.

A.

If you can save me a little time by telling which table and fields to look at, I’ll try and run a couple of tests next week. On a deadline this week.

Andy.