What SQL query to ask to remove part of the URL?

Question

MySQL

Transferred the site, and during the transfer, I don’t know why the path to the pictures changed. The path is
now
/wp-content/uploads/sites/5/2015/09/Obereg.jpg I need to make a request to remove sites/5/ , but I don’t know which one, tell me

Answer 1

Hello
Before you change anything in the database, ALWAYS make a backup.
Try like this:
Generally speaking, when migrating a site to wordpress, you usually need to change the database in several places. Read here .

Answer 2

You will have to select all entries, and in the language in which the site is written, change these places. You can use regular expressions, you can use ready-made substitution functions.