Replace a text in SQL Server Table Column

/ Published in: MySQL
Save to your folder(s)

If you have a Table which has a Column of type char or varchar or even text, and you want to change a portion of text in it for example a path. In this case you need to change the same text with new one in every records.

Copy this code and paste it in your HTML
  1. UPDATE [TableName]
  2. SET [ColumnName] = Replace([ColumnName],'OldText','NewText')


Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.