SQL

I need to replace old path's images to new path with the same image

I have a column Path_Image in table DBPaths :

 Path_Image          
 C:\Users\Pc\Desktop\archive\1.png
 D:\pics_back\22.jpg
 C:\Users\Pc\Desktop\archive\947141.JPG

And I have a new Path:

E:\pics2024

I want to replace all old paths with a new one without touch images , like this :

 Path_Image
 E:\pics2024\1.png
 E:\pics2024\22.jpg
 E:\pics2024\947141.JPG

The question is that possible and how I can do it , for me no idea how it could be?

You need to sign in to view this answers