How to use navcat to modify all wordpress domain names

How can I use navcat to modify all wordpress domain names? how can I use navcat to modify all wordpress domain names, including the domain names that have been post-published? I am useless with Ins. how can I modify navcat?

Reply to discussion (solution)

For example, you want to change the blog address from http: // www. ***. com to http ://***. com. you cannot simply modify the address in the WP background. this will cause an internal link error in the article. Next, I will share my operations.

Use SQL statements to replace navcat.

First, we will introduce the SQL replacement command.
UPDATE table name SET field = REPLACE (field, 'replace content', 'replace value ');

Example:
UPDATE wp_options SET option_value = REPLACE (option_value, 'http: // www. ***. com ', 'http: // ***. com ');

Note that the above punctuation must be in English. Where wp_options is the table name, option_value is a field in the wp_options table, and wp_options contains the siteurl and home values.

Generally, you can modify the domain name by executing the following command:

Modify the site url and homepage address in option_value:
UPDATE wp_options SET option_value = REPLACE (option_value, 'replace content', 'replace value ');

Correct the internal links and attachments in the article:
UPDATE wp_posts SET post_content = REPLACE (post_content, 'replace content', 'replace value ');

Correct the default permanent link of a wordpress article:
UPDATE wp_posts SET guid = REPLACE (guid, 'replace content', 'replace value ');

Correct your website link in a blog User: (if your personal information does not contain your blog address, ignore it)
UPDATE wp_users SET user_url = REPLACE (user_url, 'replace content', 'replace value ');

Correct your blog link in comments:
UPDATE wp_users SET user_url = REPLACE (user_url, 'replace content', 'replace value ');

Correct the comment on your blog: (skip this if the comment does not contain your blog link)
UPDATE wp_users SET comment_content = REPLACE (comment_content, 'replace content', 'replace value ');

If you have not installed the No Self Pings plug-in, perform the following operations:
UPDATE wp_posts SET pinged = REPLACE (pinged, 'replace content', 'replace value ');
UPDATE wp_posts SET to_ping = REPLACE (to_ping, 'replace content', 'replace value ');

Basically, this is where there are blog addresses. to avoid any other changes, you can search for them in phpmyadmin.
The above is your actual operation method. if you need it, you can learn it...