{"id":26597,"date":"2025-12-27T09:01:16","date_gmt":"2025-12-27T00:01:16","guid":{"rendered":"https:\/\/blog.agentsoft.co.kr\/index.php\/2025\/12\/27\/26597\/"},"modified":"2025-12-27T09:01:16","modified_gmt":"2025-12-27T00:01:16","slug":"%ec%9a%b0%ec%9a%b8%ec%9e%a5%ec%95%a0-case%ec%9e%90%ec%82%b4%ec%9c%84%ed%97%98%ec%84%b1-%ec%9e%90%ea%b0%80%ea%b0%84%ed%98%b8%ea%b2%b0%ed%95%8d-%ea%b3%84%ed%9a%8d-%ec%9d%b4%eb%a1%a0%ec%a0%81","status":"publish","type":"post","link":"https:\/\/blog.agentsoft.co.kr\/index.php\/2025\/12\/27\/26597\/","title":{"rendered":"\uc6b0\uc6b8\uc7a5\uc560 CASE(\uc790\uc0b4\uc704\ud5d8\uc131, \uc790\uac00\uac04\ud638\uacb0\ud54d) \uacc4\ud68d, \uc774\ub860\uc801\uadfc\uac70 \uc704\uc8fc!"},"content":{"rendered":"

<\/p>\n

\ubaa9\ucc28<\/strong><\/p>\n

1) \uc8fc\uc99d\uc0c1
\n2) \uc8fc\uc694 \uc0ac\uc815\ub0b4\uc6a9
\n3) \uac04\ud638\uc9c4\ub2e8
\n4) \uac04\ud638\uacc4\ud68d \ubc0f \uc774\ub860\uc801 \uadfc\uac70<\/p>\n

\ubcf8\ubb38\ub0b4\uc6a9<\/strong><\/p>\n

\uae4000\ub2d8\uc740 46\uc138\uc758 \uc5ec\uc131\uc73c\ub85c 1\uc8fc\uc77c \uc804 \uc774\ud63c\uc744 \uc694\uad6c\ud55c \ub0a8\ud3b8\uacfc \ubcc4\uac70\uc5d0 \ub4e4\uc5b4\uac04 \uc0c1\ud0dc\uc774\ub2e4. \uadf8\ub140\uc758 \uc544\ub4e4\uacfc \ub538\uc740 \uc5c4\ub9c8\uac00 \uc0ac\uc6cc\ub098 \uc2dd\uc0ac\ub97c \ud558\uc9c0 \uc54a\uace0 \uacc4\uc18d \uce68\ub300 \ub204\uc6cc \uc788\ub294 \uac83\uc744 \ubcf4\uace0 \uadf8\ub140\ub97c \ubcd1\uc6d0\uc73c\ub85c \ub370\ub9ac\uace0 \uc654\ub2e4. \uc790\ub140\ub4e4\uc740 \uc5c4\ub9c8\uac00 \uc790\uc0b4\uc0ac\uace0\uac00 \uc788\ub2e4\uace0 \ub9d0\ud558\uc600\uace0, \uc790\uc0b4\uc0ac\uace0\ub97c \uc8fc\ud638\uc18c\ub85c \uc785\uc6d0\ud588\uc9c0\ub9cc \ubaa8\ub4e0 \uc790\uc0b4\uacc4\ud68d\uc5d0 \ub300\ud574\uc11c\ub294 \ubd80\uc815\ud558\uace0 \uc788\ub2e4. \uc2e0\uccb4\uc801 \uc815\uc2e0\uc801 \ubcd1\ub825\uc774\ub098 \ubcf5\uc6a9\uc911\uc778 \uc57d\ubb3c\uc740 \uc5c6\ub294 \uc0c1\ud0dc\uc774\ub2e4. \uae4000\ub2d8\uc740 \ud55c \ub2ec \uc804 \uce5c\uad6c\ub97c \ub9c8\uc9c0\ub9c9\uc73c\ub85c \ub9cc\ub0ac\uc73c\uba70, \uc9c0\uae08\uc740 \ub354 \uc774\uc0c1 \uc544\ubb34\uac83\ub3c4 \ud558\uace0 \uc2f6\uc9c0 \uc54a\ub2e4\uace0 \ud55c\ub2e4. \ubd80\ubaa8\uc640\ub294 \uba3c \uac70\ub9ac\uc5d0 \uc0b4\uace0 \uc788\uace0, 4\uc77c \uc804 \uc7ac\uc9c1\ud558\ub358 \ud559\uad50\uc5d0 \uc804\ud654\ub97c \uac78\uc5b4 \uc544\ud504\ub2e4\uace0 \ub9d0\ud588\ub2e4\uace0 \ud55c\ub2e4. \uae4000\ub2d8\uc740 \uc785\uc6d0\ud558\uc5ec \uc8fc\ub85c \ub204\uc6cc \uc9c0\ub0b4\uc9c0\ub9cc \uc7a0\uc740 3~4\uc2dc\uac04\ub9cc \uc794\ub2e4. \uadf8\ub140\ub294 \uc6b0\uc6b8\uc99d \uc9c4\ub2e8 \ud558\uc5d0 \uc785\uc6d0\ud558\uc600\uace0, \uadf8\ub140\uc758 \uc815\uc2e0\uc0c1\ud0dc\uc0ac\uc815\uc740\uc740 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n

\ucd9c\ucc98 : \ud574\ud53c\ucea0\ud37c\uc2a4<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\ubaa9\ucc28 1) \uc8fc\uc99d\uc0c1 2) \uc8fc\uc694 \uc0ac\uc815\ub0b4\uc6a9 3) \uac04\ud638\uc9c4\ub2e8 4) \uac04\ud638\uacc4\ud68d \ubc0f \uc774\ub860\uc801 \uadfc\uac70 \ubcf8\ubb38\ub0b4\uc6a9 \uae4000\ub2d8\uc740 46\uc138\uc758 \uc5ec\uc131\uc73c\ub85c 1\uc8fc\uc77c \uc804 \uc774\ud63c\uc744 \uc694\uad6c\ud55c \ub0a8\ud3b8\uacfc \ubcc4\uac70\uc5d0 \ub4e4\uc5b4\uac04 \uc0c1\ud0dc\uc774\ub2e4. \uadf8\ub140\uc758 \uc544\ub4e4\uacfc \ub538\uc740 \uc5c4\ub9c8\uac00 \uc0ac\uc6cc\ub098 \uc2dd\uc0ac\ub97c \ud558\uc9c0 \uc54a\uace0 \uacc4\uc18d \uce68\ub300 \ub204\uc6cc \uc788\ub294 \uac83\uc744 \ubcf4\uace0 \uadf8\ub140\ub97c \ubcd1\uc6d0\uc73c\ub85c \ub370\ub9ac\uace0 \uc654\ub2e4. \uc790\ub140\ub4e4\uc740 \uc5c4\ub9c8\uac00 \uc790\uc0b4\uc0ac\uace0\uac00 \uc788\ub2e4\uace0 \ub9d0\ud558\uc600\uace0, \uc790\uc0b4\uc0ac\uace0\ub97c \uc8fc\ud638\uc18c\ub85c \uc785\uc6d0\ud588\uc9c0\ub9cc \ubaa8\ub4e0 \uc790\uc0b4\uacc4\ud68d\uc5d0 \ub300\ud574\uc11c\ub294 \ubd80\uc815\ud558\uace0 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[9301,23958,6551],"class_list":["post-26597","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-__aa","tag-23958","tag-6551"],"_links":{"self":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/26597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/comments?post=26597"}],"version-history":[{"count":0,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/posts\/26597\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/media?parent=26597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/categories?post=26597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.agentsoft.co.kr\/index.php\/wp-json\/wp\/v2\/tags?post=26597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}