Replace One Word or Phrase Through An Update Query
- Published on
- -1 min read
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')
Before you go...
If you've found this post helpful, you can buy me a coffee. It's certainly not necessary but much appreciated!
Leave A Comment
If you have any questions or suggestions, feel free to leave a comment. I do get inundated with messages regarding my posts via LinkedIn and leaving a comment below is a better place to have an open discussion. Your comment will not only help others, but also myself.
Categories
Support
If you've found anything on this blog useful, you can buy me a coffee. It's certainly not necessary but much appreciated!