SQL Update Column substring(url path) With New URL with same file name

PHOTO EMBED

Mon Feb 17 2020 07:36:12 GMT+0000 (Coordinated Universal Time)

Saved by @jayswalvishwas #android #php

UPDATE TABLE_NAME
SET COL_NAME = REPLACE(COL_NAME, 'OLD_URL/', 'NEW_URL/') where 1
content_copyCOPY

SQL Update Column substring(url path) With New URL with same file name. old url is "https://unsplash.com/photos/2S2F2exmbhw/1.html" new URL is "https://www.freepik.com/free-photo/1.htm"