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. SQL | copy code |? 1UPDATE tablename SET tablefield = REPLACE(tablefield,’oldstring’,'newstring’);


