{"id":186,"date":"2013-08-16T08:13:32","date_gmt":"2013-08-16T08:13:32","guid":{"rendered":"http:\/\/test.bleuanus.nl\/index.php\/linux\/mysql-statements\/"},"modified":"2018-12-11T16:09:09","modified_gmt":"2018-12-11T15:09:09","slug":"mysql-statements","status":"publish","type":"post","link":"https:\/\/www.bleuanus.nl\/index.php\/2013\/08\/16\/mysql-statements\/","title":{"rendered":"MySQL Statements"},"content":{"rendered":"<p class=\"last-modified\">This post was most recently updated on December 11th, 2018<\/p><h1>How to replace certain content in a MySQL database<\/h1>\n<div>\u00a0<\/div>\n<div>String to use in MySQL:<\/div>\n<div>update [table_name] set [field_name] = replace([field_name],'[string_to_find]&#8217;,'[string_to_replace]&#8217;);<\/div>\n<div>\u00a0<\/div>\n<div>Example:<\/div>\n<div>update mod_wysiwyg set content = replace(content,&#8217;84.27.217.110&#8242;,&#8217;www.bleuanus.nl&#8217;);<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This post was most recently updated on December 11th, 2018How to replace certain content in a MySQL database \u00a0 String to use in MySQL: update [table_name] set [field_name] = replace([field_name],'[string_to_find]&#8217;,'[string_to_replace]&#8217;); \u00a0 Example: update mod_wysiwyg set content = replace(content,&#8217;84.27.217.110&#8242;,&#8217;www.bleuanus.nl&#8217;);<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-186","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/posts\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/comments?post=186"}],"version-history":[{"count":1,"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/posts\/186\/revisions"}],"predecessor-version":[{"id":246,"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/posts\/186\/revisions\/246"}],"wp:attachment":[{"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/media?parent=186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/categories?post=186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bleuanus.nl\/index.php\/wp-json\/wp\/v2\/tags?post=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}