1 min read
Replace One Word or Phrase Through An Update Query
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')
