{"id":1957,"date":"2022-06-30T15:39:19","date_gmt":"2022-06-30T06:39:19","guid":{"rendered":"https:\/\/www.itchefblog.com\/?p=1957"},"modified":"2022-06-30T15:39:19","modified_gmt":"2022-06-30T06:39:19","slug":"substring_index-mysql-%ec%bf%bc%eb%a6%ac%eb%a1%9c-string-%ec%9d%98-%ed%8a%b9%ec%a0%95-%ec%9c%84%ec%b9%98%ec%9d%98-%eb%8b%a8%ec%96%b4%eb%a7%8c-%ea%b0%80%ec%a0%b8%ec%98%a4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.itchefblog.com\/?p=1957","title":{"rendered":"[SUBSTRING_INDEX] MYSQL \ucffc\ub9ac\ub85c String \uc758 \ud2b9\uc815 \uc704\uce58\uc758 \ub2e8\uc5b4\ub9cc \uac00\uc838\uc624\uae30"},"content":{"rendered":"\n<p>\ubb34\uc2a8 \ub9d0\uc778\uace0 \ud558\ub2c8&#8230;<br>\uc608\ub97c\ub4e4\uc5b4 \uc8fc\uc18c \uad00\ub828 \ud14c\uc774\ube14\uc774 \uc788\uace0, \uc8fc\uc18c\uac00 &#8216;\uc11c\uc6b8\uc2dc \uac15\ub0a8\uad6c \uc5ed\uc0bc\ub3d9&#8217;\uacfc \uac19\uc774 \uc800\uc7a5\ub418\uc5b4\uc788\uc744 \ub54c, \ub9c8\uc9c0\ub9c9\uc758 &#8216;\uc5ed\uc0bc\ub3d9&#8217; \uc774\ub77c\ub294 \ub2e8\uc5b4\ub9cc \ucd94\ucd9c\ud558\uace0 \uc2f6\uc744 \ub54c, \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774\ub2e4.<\/p>\n\n\n\n<p>SELECT SUBSTRING_INDEX(TRIM(address), &#8216; &#8216;, -1) FROM addresses;<\/p>\n\n\n\n<p>SUBSTRING_INDEX\uc744 \uc774\uc6a9\ud558\uba74 string\uc744 \ud2b9\uc815 \ubb38\uc790\ub85c split\ud55c \ud6c4 \ud2b9\uc815 index\uc5d0 \ud574\ub2f9\ud558\ub294 \ubb38\uc790\ub97c \ubc18\ud658\ud560 \uc218 \uc788\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ubb34\uc2a8 \ub9d0\uc778\uace0 \ud558\ub2c8&#8230;\uc608\ub97c\ub4e4\uc5b4 \uc8fc\uc18c \uad00\ub828 \ud14c\uc774\ube14\uc774 \uc788\uace0, \uc8fc\uc18c\uac00 &#8216;\uc11c\uc6b8\uc2dc \uac15\ub0a8\uad6c \uc5ed\uc0bc\ub3d9&#8217;\uacfc \uac19\uc774 \uc800\uc7a5\ub418\uc5b4\uc788\uc744 \ub54c, \ub9c8\uc9c0\ub9c9\uc758 &#8216;\uc5ed\uc0bc\ub3d9&#8217; \uc774\ub77c\ub294 \ub2e8\uc5b4\ub9cc \ucd94\ucd9c\ud558\uace0 \uc2f6\uc744 \ub54c, \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774\ub2e4. SELECT SUBSTRING_INDEX(TRIM(address), &#8216; &#8216;, -1) FROM addresses; SUBSTRING_INDEX\uc744 \uc774\uc6a9\ud558\uba74 string\uc744 \ud2b9\uc815 \ubb38\uc790\ub85c split\ud55c \ud6c4 \ud2b9\uc815 index\uc5d0 \ud574\ub2f9\ud558\ub294 \ubb38\uc790\ub97c \ubc18\ud658\ud560 \uc218 \uc788\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,19],"tags":[],"_links":{"self":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/1957"}],"collection":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1957"}],"version-history":[{"count":1,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/1957\/revisions"}],"predecessor-version":[{"id":1958,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=\/wp\/v2\/posts\/1957\/revisions\/1958"}],"wp:attachment":[{"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itchefblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}