Find and Replace in SQL

Hack on October 20th, 2011 No Comments

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’);

Tags: , ,