Find and Replace in SQL

This is a very useful code for making edits on the fly, especially if you have extra spacing or quotes after importing values into your database.
UPDATE tablename SET tablefield = replace(tablefield,'oldstring','newstring');