SQL update column values with substring value

Question

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

Answer 1

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 ', '');