WordPress tips: How to batch replace WordPress site URL link addresses by using SQL commands

After a blog has been running for a long time, it is inevitable that the address will be changed in batches. The solution Woyuan sometimes uses is to use the editor to modify the address in batches. Most of the time it is effective, but last night when modifying the address in batches, I found that After importing the modified database backup, the theme data always returned to the default phenomenon, so I found a way to use SQL commands directly on the phpMyAdmin database management page to make batch modifications. I simply recorded it here for my own convenience in the future.

The operation commands are as follows:

UPDATE wp_posts SET post_title = REPLACE( post_title, 'woyard789', '987drayow' );

As shown below, Snail wants to change the wn789.com address of the article page to 789wn.com, so the command used is:

UPDATE wp_posts SET post_content = REPLACE( post_content, 'woyard789', '987drayow' );

Where "YourDBName_posts" is equal to the "wp_posts" table name of your database. If some friends have modified the database table prefix name when installing the WordPress program, please change it to your own corresponding name.

3. Modify tag content in batches

update wp_terms set name = replace(name,'woyard789', '987drayow')

4. Modify article abstracts in batches

UPDATE wp_posts SET post_excerpt = REPLACE( post_excerpt, 'woyard789', '987drayow' );

5. Where to modify?

After entering the database management page through phpmyadmin, just press the image below.

Recommended site search: Mainland China registration-free host, US server website, Hong Kong virtual host space, registration center, foreign server rental, space rental, proxy ip, virtual host rental, 1g US virtual host, dual-line host rental, < /p>