WordPress batch change domain name sql operation statement

The general modification method is to click and modify one database table at a time, but this method is too inefficient. If you encounter a large number of never-path addresses in the article, the workload is even greater. At this time, we can implement batch modification by executing the sql statement in phpmyadmin. (If you don’t understand the database, you can first learn the introductory knowledge of website database.)

The operation method is very simple. You only need to open the database management phpmyadmin interface of the website space, find the sql button, and enter the following statement:
WordPress batch change domain name sql operation statement

The following are several commonly used sql statements, which can be used according to your needs.
Modify the statement in the configuration table:

UPDATE wp_options SET option_value = replace( option_value, ‘old domain’, ‘new domain’);
Modify the statement of the absolute address in the article:

UPDATE wp_options SET option_value = replace( option_value, ‘old domain’, ‘new domain’);
UPDATE wp_posts SET post_title = replace( post_title, ‘old domain’, ‘new domain’);
UPDATE wp_posts SET post_content = replace( post_content, ‘old domain’, ‘new domain’);
UPDATE wp_posts SET guid = replace( guid, ‘old domain name address’, ‘new domain name address’);
UPDATE wp_postmeta SET meta_value = replace( meta_value, ‘old domain’, ‘new domain’);
UPDATE wp_termmeta SET meta_value = replace( meta_value, ‘Old domain’, ‘New domain’);
Modify the statement in the comment:

UPDATE wp_comments SET comment_content = replace(comment_content, ‘Old domain’, ‘New domain’);
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, ‘Old domain’, ‘New domain’);