I was used to do something like

update wp_posts set post_content = replace(post_content,'', '');

This seems not to work anymore for texts that come from Gutenberg.

Any idea/update for this?

I was used to do something like

update wp_posts set post_content = replace(post_content,'http://dev.example/website', 'http://www.website');

This seems not to work anymore for texts that come from Gutenberg.

Any idea/update for this?

• images
• database
• sql
• block-editor
• migration

Share Improve this question asked Oct 23, 2019 at 18:14 Luca ReghellinLuca Reghellin 1,64222 gold badges2121 silver badges4545 bronze badges 1

• 1 The Block Editor still keeps image URLs in the database, so if your query was working before, the editor isn't the reason it's not working now. Maybe your database has grown too large for the one query affecting every single post to run? You could try doing it in batches instead of every single post at once, i.e. include a WHERE "ID" < 100 clause. – WebElaine Commented Oct 23, 2019 at 18:45

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

I just found out the reason. It's because I'm using ACF Pro as Blocks. The data will be written in database in json format, and the urls will escape all the slashes ad double quotes. So for example

src=\"http:\/\/dev.example\/website\/wp-content\/uploads\/2019\/10\/identity.jpg\"

So I should add a row like this:

update wp_posts set post_content = replace(post_content,'http:\/\/dev.example\/website', 'http:\/\/www.website');