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’);
I'm a business & technology developer based out of Indianapolis, IN. My passion is to develop and execute leading‐edge e‐commerce and e‐business solutions, Internet technologies and telecommunications strategies to penetrate B2C & B2B markets.
I am fortunate to have been featured in the multiple publications, including:
I have developed, managed and maintained IT strategic plans, asset and lifecycle management for hundreds of websites, from personal & small business websites all the way to eCommerce websites.
Every project I build, lead, and foster are built using the latest development principles and techniques.