String Replace in mysql

Say that you have a database full of blog posts and by chance you have misspelled a word many times throughout your blogging. You may think that you will have to go back and edit each of your blog posts but if you have access to the database you can run a replace on all of them and fix your mistake. String replacements in mysql are pretty simple, the standard syntax being REPLACE([string or column],'thing to replace','thing to substitute') You could run a replace update query on your blog post d... read more!

Oct 16, 2009 12:43pm by Mike Vandenberghe

Posted in technology | Post Comment