I'm making migration from wix platform to wordpress. So, a part of content was copied using CTRL+C CTRL+V, and images link look ugly. I need to make them internal from externals, but first of all I need to change links. They should normal image links. So, what I'm talking about.
Image link in many post looks like
but better if it would be
Change them manually is bad idea, because I have around 100-150 posts and in each I have about 10 such images.
The solve that I see is to make an SQL-query, that would cut useless part of link for me. But I can't imaginate how it should look.