SQL query to patching text fields in Database where text contains specific string [duplicate]

Question

I have a table with a text field info which contains text and urls. Something like `

Sometext <_a href="https://Asite.com/path">Link<_/a> sometext

I want to patch this text field and get

Sometext <_a href="https://Bsite.com/path">Link<_/a> sometext

I want to go through all these text fields and change all links inside the column info. Is there any SQL condition to implement this?

user6277510 · Accepted Answer · 2018-04-21 20:31:37Z

0

You can use the SQL Replace() function. Like this:

UPDATE TestTable
SET info = REPLACE(info, 'https://Asite.com/path', 'https://Bsite.com/path')
WHERE info like '%https://Asite%'

answered Apr 21, 2018 at 20:31

user6277510

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

1 Answer 1