Replacing a string in a text field

Question

Hello,

I have a column in my database table which has lows of text and lows of rows. In the text, a url needs to be changed for every row. In each row the url can exist more than once.

Can I use the replace function to change all the urls in the text field in my database table without affecting the rest of the text in that same column?

Thanks

Answer 1

Use REPLACE()

UPDATE table SET text = REPLACE(text, 'from', 'to')

Make precise from: like with http://url_from.com/ to http://url_to.com/