#mssql replace in update

[garvita]

Fixing string data in mssql

Replace function in MSSQL does all the magic. If you want to change the text in a select statement something like this will work:

select replace (url, 'site1.com','site2.com') url from file_data where id = 12307

Alternatively if you want to update the data in table

update file_data set url = replace (url, 'site1.com','site2.com') where id = 12307

The same exact statement works in mysql as well.