{"id":704,"date":"2023-02-21T16:36:04","date_gmt":"2023-02-21T07:36:04","guid":{"rendered":"https:\/\/blog.mydepot.kr\/?p=704"},"modified":"2023-02-21T16:36:04","modified_gmt":"2023-02-21T07:36:04","slug":"mysql-json-%ec%97%b4%ec%97%90%ec%84%9c-%ed%95%b4%eb%8b%b9-%ea%b0%92-%ec%b6%94%ea%b0%80-%ec%82%ad%ec%a0%9c","status":"publish","type":"post","link":"https:\/\/blog.mydepot.kr\/?p=704","title":{"rendered":"[mysql] json \uc5f4\uc5d0\uc11c \ud574\ub2f9 \uac12 \ucd94\uac00\/\uc0ad\uc81c"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n\/\/ \uac80\uc0c9 \ud6c4 \uceec\ub7fc\uc5d0 \uac12\uc774 \uc5c6\uc73c\uba74 \ucd94\uac00 (\uc788\uc73c\uba74 \ubb34\uc2dc)\nUPDATE \ud14c\uc774\ube14\uba85 SET\n`\uceec\ub7fc\uba85` = IF(JSON_CONTAINS(`\uceec\ub7fc\uba85`, &#039;&quot;\uac80\uc0c9(\uc0bd\uc785)\uac12&quot;&#039;), `\uceec\ub7fc\uba85`, JSON_ARRAY_APPEND(`\uceec\ub7fc\uba85`, &#039;$&#039;, &quot;\uac80\uc0c9(\uc0bd\uc785)\uac12&quot;))\nWHERE \uc870\uac74\uceec\ub7fc = &quot;\uc870\uac74\uac12&quot;\n\n\/\/ \uac80\uc0c9 \ud6c4 \uceec\ub7fc\uc5d0 \uac12\uc774 \uc788\uc73c\uba74 \uc0ad\uc81c (\uc5c6\uc73c\uba74 \ubb34\uc2dc)\nUPDATE \ud14c\uc774\ube14\uba85 \nSET `\uceec\ub7fc\uba85` = JSON_REMOVE(`\uceec\ub7fc\uba85`, JSON_UNQUOTE(JSON_SEARCH(`\uceec\ub7fc\uba85`, &#039;one&#039;, &#039;\uac80\uc0c9(\uc0bd\uc785)\uac12&#039;)))\nWHERE \uc870\uac74\uceec\ub7fc = &quot;\uc870\uac74\uac12&quot; AND JSON_SEARCH(`\uceec\ub7fc\uba85`, &#039;one&#039;, &#039;\uac80\uc0c9(\uc0bd\uc785)\uac12&#039;) IS NOT NULL \n<\/pre><\/div>\n\n\n<p>json \uceec\ub7fc \uac12\uc758 \ud615\ud0dc\uac00 \ubc30\uc5f4\uc77c \uacbd\uc6b0\uc5d0 \ud574\ub2f9\ud55c\ub2e4.<\/p>\n\n\n\n<p>\ud0a4\uac00 \ub530\ub85c \uc788\uc744 \uacbd\uc6b0\uc5d0\ub294 \ub610 \ub2e4\ub974\uac8c \uc218\uc815\ud574\uc11c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>json \uceec\ub7fc \uac12\uc758 \ud615\ud0dc\uac00 \ubc30\uc5f4\uc77c \uacbd\uc6b0\uc5d0 \ud574\ub2f9\ud55c\ub2e4. \ud0a4\uac00 \ub530\ub85c \uc788\uc744 \uacbd\uc6b0\uc5d0\ub294 \ub610 \ub2e4\ub974\uac8c \uc218\uc815\ud574\uc11c \uc0ac\uc6a9\ud574\uc57c \ud55c\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[9],"tags":[162,163,205,302],"class_list":["post-704","post","type-post","status-publish","format-standard","hentry","category-sql","tag-mysql","tag-163","tag-query","tag-json"],"modified_by":"\ucc38\ube5b\ubc14\ub2e4","_links":{"self":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/704","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=704"}],"version-history":[{"count":1,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/704\/revisions"}],"predecessor-version":[{"id":705,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/704\/revisions\/705"}],"wp:attachment":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}