SQL update column values with substring value [duplicate]

Question

So my table is https://i.sstatic.net/kdGp6.jpg. I want to update the name column so that it removes the Telefon mobil part(to look like the first row).

Madhur Bhaiya · Accepted Answer · 2018-09-07 17:39:15Z

2

Use REPLACE function, to replace the specific substring with an alternate substring in the name field:

UPDATE table_name 
SET name = REPLACE(name, 'Telefon mobil ', '');

edited Sep 7, 2018 at 17:39

answered Sep 7, 2018 at 17:32

Madhur Bhaiya

28.9k10 gold badges53 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RToyo Over a year ago

Only suggestion is that you may want to replace the space after "mobil" as well, so that the text does not have a leading space. IE: 'Telefon mobil '.

Madhur Bhaiya Over a year ago

@Rtoyo ya just added that.

Collectives™ on Stack Overflow

SQL update column values with substring value [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related