Blog

Tagged by 'word'

Published on
Apr 04, 2010-
1 min read
Replace One Word or Phrase Through An Update Query
#phrase #replace #sql #update-query #word
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')
```

Featured Posts

Disqus was adding around 1.6MB-2MB of additional bloat to a page and I needed a more efficient way of using the commenting platform.

SimpleLogin.io - An Email Service I Never Thought I Needed... Until Now

SimpleLogin's email alias service has completely transformed how I create new email addresses while also providing additional privacy and security features.

Stack Overflow Trigger-Happy Downvoting

Stack Overflow is one of the best resources to get answers to any tech question. I'm trying to make sense of 'trigger-happy' downvoting that goes on at times without any clear context as to why?

Support

If you've found anything on this blog useful, you can buy me a coffee. It's certainly not necessary but much appreciated!

Replace One Word or Phrase Through An Update Query

Featured Posts