{"id":330,"date":"2011-04-21T09:54:02","date_gmt":"2011-04-21T09:54:02","guid":{"rendered":"https:\/\/www.taywa.ch\/blog\/?p=330"},"modified":"2011-04-21T09:54:57","modified_gmt":"2011-04-21T09:54:57","slug":"substring-in-datenbank-ersetzen","status":"publish","type":"post","link":"https:\/\/www.taywa.ch\/blog\/mysql\/substring-in-datenbank-ersetzen\/","title":{"rendered":"Substring in Datenbank Feld ersetzen"},"content":{"rendered":"<p><strong>Problem:<\/strong> In einer MySQL Datenbank sind in einem Feld unterschiedliche Strings abgespeichert, in denen man nur einen bestimmten Teil (substring) \u00e4ndern\/ersetzen muss.<\/p>\n<p><strong>L\u00f6sung:<\/strong> Erstaunlich einfach &#8211; es reicht ein einziges MySQL Statement:<\/p>\n<div class=\"mysql dean_ch\"><span class=\"co2\"># &#8218;tabellen_name&#8216; (1x) und &#8218;feld_name&#8216; (2x) m\u00fcssen<\/span><br \/>\n<span class=\"co2\"># nat\u00fcrlich mit den richtigen namen ersetzt werden<\/span><br \/>\n&nbsp;<br \/>\n<a href=\"http:\/\/search.mysql.com\/search?site=refman-%35%31&amp;q=UPDATE\"><span class=\"kw1\">UPDATE<\/span><\/a> tabellen_name <a href=\"http:\/\/search.mysql.com\/search?site=refman-%35%31&amp;q=SET\"><span class=\"kw1\">SET<\/span><\/a> feld_name<span class=\"sy1\">=<\/span><span class=\"br0\">&#40;<\/span><a href=\"http:\/\/search.mysql.com\/search?site=refman-%35%31&amp;q=REPLACE\"><span class=\"kw2\">REPLACE<\/span><\/a> <span class=\"br0\">&#40;<\/span>feld_name<span class=\"sy2\">,<\/span> <span class=\"st0\">&#8218;alter text&#8216;<\/span><span class=\"sy2\">,<\/span> <span class=\"st0\">&#8217;neuer text&#8216;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy2\">;<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Problem: In einer MySQL Datenbank sind in einem Feld unterschiedliche Strings abgespeichert, in denen man nur einen bestimmten Teil (substring) \u00e4ndern\/ersetzen muss. L\u00f6sung: Erstaunlich einfach &#8211; es reicht ein einziges MySQL Statement: # &#8218;tabellen_name&#8216; (1x) und &#8218;feld_name&#8216; (2x) m\u00fcssen # nat\u00fcrlich mit den richtigen namen ersetzt werden &nbsp; UPDATE tabellen_name SET feld_name=&#40;REPLACE &#40;feld_name, &#8218;alter text&#8216;,<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[185],"class_list":["post-330","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts\/330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/comments?post=330"}],"version-history":[{"count":5,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts\/330\/revisions"}],"predecessor-version":[{"id":335,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts\/330\/revisions\/335"}],"wp:attachment":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/media?parent=330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/categories?post=330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/tags?post=330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}