0 points

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


dashboard

Mon Feb 17 2020 07:36:12 GMT+0000 (UTC)

Posted by @jayswalvishwas #android #php

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

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"



>> Browse more code snippets

more_vert