Find and Replace in SQL Databases

Most of us have used the find and replace function in word processors, but is there a similar feature for finding and things in SQL databases? Yes there is.

First of all, as is always the case, make sure you backup your SQL Database in case something unexpected occurs (especially errors between your keyboard and your seat) while you are working on it.


run your database find and replace operation based on the SQL command below:


So for instance, let's say that within your database you have a table named "articles" and in that table there is a field named "introduction". If you want to replace (in that field) every occurance of the word "free" with "almost free", the SQL command would look like this:

update articles set introduction = replace(introduction, 'free','almost free')

Just remember to be very careful when you "find and replace" things in your database or you may end up finding and replacing more than you want. The above example will also change everwhere "freedom" occurs to "almost freedom" and you might find your options to repair that mistake to restoring your backup.>

Rev James Snyder videoPastor Tim has retired from pastoring local churches and is now working alongside his wife to help refugees and persecuted Christians.

For more about Cybersalt, the business, head on over to www.cybersalt.com