If the previously added custom column values, such as attachments or image link addresses, have changed, you can modify them in batches by using the following methods.
Add the following code to the end of the current topic function template functions.php:
global $wpdb; $wpdb->query("UPDATE wp_postmeta SET meta_value = replace( meta_value, ' https://www.baidu.com/ ',' https://down.baidu.com/ ')");
The above example is applicable to modifying only the domain name in the link address, not the link behind the domain name.
For example: https://www.baidu.com/2020/01/ file.zip
Replace with: https://down.baidu.com/2020/01/file.zip
Others can be deduced by analogy.
After adding code, refresh the web page and replace it.
Please backup the data before operation, just in case!
After replacement, please remove the above code.
Most of the articles on this site are original and used for personal learning records, which may be helpful to you, for reference only!
