Check live the Example http://sqlfiddle.com/#!9/9d3c4 We are basing the example on a table with varchar records CREATE TABLE uno ( str varchar(255) ); insert into uno VALUES ( 'anteprima/image/descriptions/555b2343cb43a-555b2343c94f3-wink_smile.gif'); insert into uno VALUES ( 'anteprima/image/descriptions/555b2343cb43a-dd3b2343c94f3-wink_smile.gif'); insert into uno VALUES ( 'anteprima/image/descriptions/555b2343cb43a-555b2343c94f3-wink_smiles.gif'); insert into uno VALUES ( 'anteprima/image/descriptions/555b2343cb43a-555b2343c94f3d-wink_smile.gif'); insert into uno VALUES ( 'anteprima/image/descriptions/555b2343cb43a-555b2343c9qdq4f3-wink_smile.gif'); ___ We want to REPLACE 'anteprima/image/descriptions/' with 'image/catalog/descriptions/' within each record. UPDATE uno set str = replace(str, 'anteprima/image/descriptions/', 'image/catalog/descriptions/'); It's useful, for example, to move imag...