Replace Text in a Database

If you need to perform an update on some text value in your database, you can easily get the job done using the REPLACE() function. I strongly suggest using the WHERE clause. You don’t want to accidentally update a row you didn’t mean to. I…

Text replace

A nice simple post today. This is probably well known, but I useful one to know. Below is the syntax for the REPLACE function. As you can see, the first parameter is the source string, second is the text to replace, and the third is…