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 | | ? |
| 1 | UPDATE tablename SET tablefield = REPLACE(tablefield,'oldstring','newstring'); |
» @AmExperiencePBS Milton, Massachusetts
» @PatMcAfeeShow #SmokeFreeIndy - Here's a banner I created for the campaign: http://t.co/vU4V4LWn
» RT @FillWerrel: Whenever someone calls me ugly, I get super sad and hug them, because I know how tough life is for the visually impaired.
» RT @chachaman: Android Siri clone Iris teams with ChaCha for giant info database http://t.co/ruisXr62
» RT @oneclick: Web developer positions will be the most difficult to fill this year http://t.co/RXoOCq3H
I'm a web designer & developer based out of Indianapolis, IN. The majority of my time is spent utilizing XHTML, CSS, JavaScript (jQuery), PHP, MySQL, ASP.NET and SQL.
I am fortunate to have been featured in the multiple publications, including:
I have worked on hundreds of websites, from personal & small business websites all the way to eCommerce websites.
Each site I develop is built to be search engine friendly, using the latest development principles and techniques.
