I am migrating website and I changed my mind about url path where my images are stored. Before the path looked like: files/name-of-article/image.jpg now I would like to change it to files/img/name-of-article/image/jpg. How it is possible to replace "files" with "files/img" string? I found following sql code but it works only for replacing whole urll path.
UPDATE field_data_body SET body_value = REPLACE(body_value,'src="/olddirectory','src="/newdirectory');