database.

How to Replace Text or URL in a MySQL Database (Serialized-Safe,)

Raw SQL REPLACE corrupts serialized WordPress data. Three correct approaches that survive migration: WP-CLI, the standalone PHP script, and the admin plugin.