EN / ZH
How to Replace All Image URLs in WordPress Posts

In some cases, you may need to batch-replace all image URLs in your WordPress posts. This can be accomplished by running a simple SQL statement.
Here’s how:

Run the following SQL statement:

SQL query:

UPDATE wp_posts SET post_content = REPLACE (post_content, 'www.aips.me', 'imzl.com')

This statement will replace all image URLs containing www.aips.me with imzl.com in your post content.

It’s essentially a SQL find-and-replace function:

UPDATE table_name SET field_name = REPLACE (field_name, 'aaa', 'bbb');

With this method, you can easily batch-replace any content in your WordPress posts, including image URLs.