{"id":6254,"date":"2023-07-05T16:27:30","date_gmt":"2023-07-05T07:27:30","guid":{"rendered":"https:\/\/nsme.net\/notes\/?p=6254"},"modified":"2023-07-05T16:27:30","modified_gmt":"2023-07-05T07:27:30","slug":"%e6%96%87%e5%ad%97%e5%88%97%e7%bd%ae%e6%8f%9b%e3%80%80replace","status":"publish","type":"post","link":"https:\/\/core.nsme.net\/notes\/mysql\/%e3%83%86%e3%83%bc%e3%83%96%e3%83%ab%e6%93%8d%e4%bd%9c\/6254\/","title":{"rendered":"\u6587\u5b57\u5217\u7f6e\u63db\u3000REPLACE"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u30ab\u30e9\u30e0\u5185\u4e00\u90e8\u7f6e\u63db\u3057\u305f\u3044\u3068\u304d<br>\u30b5\u30f3\u30d7\u30eb<br>\u5168\u89d2\u6570\u5b57\u3092\u534a\u89d2\u3078<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff10','0') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff11','1') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff12','2') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff13','3') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff14','4') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff15','5') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff16','6') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff17','7') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff18','8') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uff19','9') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\u5186','') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'\uffe5','') WHERE meta_key = 'cost';\nUPDATE wp_postmeta SET meta_value = REPLACE(meta_value,',','') WHERE meta_key = 'cost';<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u30ab\u30e9\u30e0\u5185\u4e00\u90e8\u7f6e\u63db\u3057\u305f\u3044\u3068\u304d\u30b5\u30f3\u30d7\u30eb\u5168\u89d2\u6570\u5b57\u3092\u534a\u89d2\u3078<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[43],"tags":[],"class_list":["post-6254","post","type-post","status-publish","format-standard","hentry","category-43"],"acf":[],"_links":{"self":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6254","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/comments?post=6254"}],"version-history":[{"count":1,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6254\/revisions"}],"predecessor-version":[{"id":6255,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/posts\/6254\/revisions\/6255"}],"wp:attachment":[{"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/media?parent=6254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/categories?post=6254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/core.nsme.net\/notes\/wp-json\/wp\/v2\/tags?post=6254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}