how to update string in Table in sql Database using SQL Server

in this post we will learn how to update string in Table in sql Database using SQL Server so you need to copy and paste in sql query window and modify yourself.

update my_table
set path = replace(path, 'oldstring', 'newstring')

Check Condition with where clause

update tblpost_wp
set post_content = replace(post_content, '<code class="language-cs">', '') where post_name_wp='how-to-create-register-windows-form-aspnet-using-c23c2a0'