DEV Community

Ganesh Dhumal
Ganesh Dhumal

Posted on

Answer: Update a column value, replacing part of a string

answer re: Update a column value, replacing part of a string
Apr 16 '12
230 
UPDATE yourtable
SET url = REPLACE(url, 'http://domain1.example/images/', 'http://domain2.example/otherfolder/')
WHERE url LIKE ('http://domain1.example/images/%');

relevant docs: http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_replace

Open Full Answer

Top comments (0)

Read next

kwan profile image

Mentoring for Women in IT: How to Get the Most Out of It

KWAN -

franciscojeg78 profile image

Descifrando AWS SAA-C03: una guía de preparación para el mundo real (Spanish Version)

Francisco Escobar -

mostefa_brougui profile image

Enhancing Data Security with Spark: A Guide to Column-Level Encryption - Part 2

Mostefa Brougui -

bvs_karthik profile image

Managing and Securing Access to AWS Resources Using IAM

BVS KARTHIK -