'Remove a piece from a string from a big database

I have a database like this

and it goes on for like 2.7m more lines.

Is there an SQL condition where I can remove the identifier from the titleurl in the whole column?

Thank you!

sql

Solution 1:^[1]

use SQL replace() so you can do it something like this

SELECT

SELECT REPLACE(titleurl , identifier, '') FROM your_table

UPDATE

UPDATE your_table SET titleurl = REPLACE(titleurl , identifier, '')

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1