{"id":645,"date":"2022-09-16T11:34:28","date_gmt":"2022-09-16T02:34:28","guid":{"rendered":"https:\/\/blog.mydepot.kr\/?p=645"},"modified":"2022-09-16T11:40:24","modified_gmt":"2022-09-16T02:40:24","slug":"mysql-json-%ec%97%b4%ec%97%90-%eb%b0%b0%ec%97%b4%ea%b0%92%ec%9d%b4-%ec%9e%88%ec%9d%84-%ea%b2%bd%ec%9a%b0-%eb%b0%b0%ec%97%b4-%ea%b0%92-%ea%b2%80%ec%83%89%ed%95%98%ea%b8%b0-%ec%9d%bc%ec%b9%98","status":"publish","type":"post","link":"https:\/\/blog.mydepot.kr\/?p=645","title":{"rendered":"[mysql] json \uc5f4\uc5d0 \ubc30\uc5f4\uac12\uc774 \uc788\uc744 \uacbd\uc6b0 \ubc30\uc5f4 \uac12 \uac80\uc0c9\ud558\uae30 (\uc77c\uce58)"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT * from \ud14c\uc774\ube14\uba85 WHERE JSON_CONTAINS(\uc5f4\uc774\ub984, &#039;\uac12&#039;)\n<\/pre><\/div>\n\n\n<p>\uac12\uc774 \ub530\uc634\ud45c\ub85c \uc2f8\uc5ec \uc788\uc73c\uba74 \ub530\uc634\ud45c\uae4c\uc9c0 \ub123\uc5b4\uc11c \ucffc\ub9ac\ub97c \uc791\uc131\ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uac12\uc774 \ub530\uc634\ud45c\ub85c \uc2f8\uc5ec \uc788\uc73c\uba74 \ub530\uc634\ud45c\uae4c\uc9c0 \ub123\uc5b4\uc11c \ucffc\ub9ac\ub97c \uc791\uc131\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,205,302],"class_list":["post-645","post","type-post","status-publish","format-standard","hentry","category-sql","tag-mysql","tag-query","tag-json"],"modified_by":"\ucc38\ube5b\ubc14\ub2e4","_links":{"self":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/645","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=645"}],"version-history":[{"count":1,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/645\/revisions"}],"predecessor-version":[{"id":646,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=\/wp\/v2\/posts\/645\/revisions\/646"}],"wp:attachment":[{"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.mydepot.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}