snipplrCallback({"id":27969,"title":"sql-using-replace-in-an-update-statement","source":"<pre class=\"sql\"><ol><li class=\"li1\"><div class=\"de1\"><span class=\"kw1\">UPDATE<\/span> biggiesmalls <span class=\"kw1\">SET<\/span> title <span class=\"sy0\">=<\/span> <span class=\"kw1\">REPLACE<\/span><span class=\"br0\">&#40;<\/span>title<span class=\"sy0\">,<\/span> <span class=\"st0\">'Mr Jones'<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">'Mr Grieves'<\/span><span class=\"br0\">&#41;<\/span>;<\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/27969\/sql-using-replace-in-an-update-statement"});