Batch replace wordpress article content

Source: Internet
Author: User
For mysql users, this problem is simple, but wordpress users do not necessarily understand mysql. You can use the mysql management tool in the idc background to modify it. The phpmyadmin tool is generally used. Note: before the operation, you must back up and open the database used by wordpress. Click the SQL menu and execute the following SQL statement: UPDATE 'wp _ posts' SET

For mysql users, this problem is simple, but wordpress users do not necessarily understand mysql. You can use the mysql management tool in the idc background to modify it. The phpmyadmin tool is generally used. Note: before the operation, you must back up and open the database used by wordpress. Click the SQL menu and execute the following SQL statement: UPDATE 'wp _ posts' SET

For mysql users, this problem is simple, but wordpress users do not necessarily understand mysql.

You can use the backend mysql management of the idc to modify the configuration. The common tool is phpmyadmin.

Note: Make sure to back up data before the operation.

Open the database used by wordpress, click the SQL menu, and execute the following SQL statement:

UPDATE 'wp _ posts' SET 'Post _ content' = replace ('Post _ content', 'old', 'new ');

Wp_posts: wordrepss article content table

Post_content: Content Column

Replace (): Execute the replacement function.

Old: content to be replaced

New: new Content

Original article address: Replace the wordpress article content in batches. Thank you for sharing the original article.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.