A query to substitute images paths in gutenberg (website migration)?

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.com\/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.com\/website', 'http:\/\/www.website.com');