Update to remove a piece of a varchar field

Question

I have a column with a varchar field. In this column has a value like this:

http://dominio/img//12.jpg

I want to do an update that leaves this field like this:

http://dominio/img/12.jpg

That // I want to remove always starts at a fixed position on the string.

How I would do this update?

The update is in the whole table.

Answer 1

Very simple, in fact:

UPDATE TABELA
SET COLUNA = REPLACE(REPLACE(COLUNA, '//', '/'), 'http:/', 'http://');

I made you a Fiddle.

See more about the REPLACE here.