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