Replace One Word or Phrase Through An Update Query

4 April 2010 by Surinder Bhomra in Databases & SQL  //   Comments

UPDATE queries are great to modify all information stored within our column. But what if we needed to only update a specific phrase or word within our column?

Well, we can use an UPDATE query along with a REPLACE function. It can be used like this:

UPDATE <table_name>
SET <column_name> = Replace(<column_name>, 'old phrase', 'new phrase')
blog comments powered by Disqus

About

Surinder Bhomra is a Web Developer.

He has achieved a BSc in Information Systems in 2006 and since then has been working in the IT industry.

Prior to working in the Web Development industry I have spent 1.5 years working as an IT Systems Analyst providing support for internal company systems.

Working in the Web Development industry has given me the opportunity to expand my current skills and allowing me to work on website projects using ASP, ASP.NET, CSS, HTML and SQL.

StackOverflow Flair

profile for sbhomra at Stack Overflow, Q&A for professional and enthusiast programmers

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer’s view in any way.

>