{"id":2248,"date":"2015-09-15T05:20:18","date_gmt":"2015-09-15T05:20:18","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2248"},"modified":"2017-01-26T22:39:41","modified_gmt":"2017-01-26T13:39:41","slug":"postgresql%ec%9d%98-like-%ea%b2%80%ec%83%89","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2248","title":{"rendered":"PostgreSQL\uc758 LIKE \uac80\uc0c9"},"content":{"rendered":"<p><P>\uc774 \uae00\uc758 \uc6d0\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/P><\/p>\n<p><P><CENTER>http:\/\/www.tutorialspoint.com\/postgresql\/postgresql_like_clause.htm<\/CENTER><\/P><\/p>\n<p><P>PostgreSQL\uc740 \uc5d4\ud130\ud504\ub77c\uc774\uc988\uae09\uc758 \ub300\uc6a9\ub7c9\uc758 \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0 \uc801\ud569\ud55c \uc548\uc815\uc801\uc778 DBMS\uc785\ub2c8\ub2e4. \uc774\uae00\uc740 SELECT \ubb38\uc5d0\uc11c LIKE \uac80\uc0c9\uc5d0 \ub300\ud574 \uac04\ub2e8\ud788 \uc815\ub9ac\ud55c \uae00\uc785\ub2c8\ub2e4.<\/P><\/p>\n<p><P>LIKE \uac80\uc0c9\uc5d0\uc11c \uc8fc\uc694\ud55c 2\uac00\uc9c0 \ud2b9\uc218\ubb38\uc790\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/P><\/p>\n<p><UL><LI>Percent Sign(%) : 0\uac1c \uc774\uc0c1\uc758 \ubd88\ud2b9\uc815 \ubb38\uc790\ub97c \ub098\ud0c0\ub0c4<\/LI><LI>Under Score(_) : 1\uac1c\uc758 \ubd88\ud2b9\uc815 \ubb38\uc790\ub97c \ub098\ud0c0\ub0c4<\/LI><\/UL><\/p>\n<p><P>LIKE \uac80\uc0c9\uc758 \uc608\uc640 \uadf8 \uacb0\uacfc\uc5d0 \ub300\ud55c \uc124\uba85\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/P><\/p>\n<p><UL><LI>WHERE SALARY::text LIKE &#8216;200%&#8217; &#8211; 200\uc73c\ub85c \uc2dc\uc791\ud558\ub294 \ubaa8\ub4e0 \uac12\uc744 \uac80\uc0c9\ud568<\/LI><LI>WHERE SALARY::text LIKE &#8216;%200%&#8217; &#8211; 200\uc744 \ud3ec\ud568\ud558\ub294 \ubaa8\ub4e0 \uac12\uc744 \uac80\uc0c9\ud568<\/LI><LI>WHERE SALARY::text LIKE &#8216;_00%&#8217; &#8211; \ub450\ubc88\uc9f8 \ubd80\ud130 00\uc73c\ub85c \uc2dc\uc791\ud558\ub294 \ubaa8\ub4e0 \uac12\uc744 \uac80\uc0c9\ud568<\/LI><LI>WHERE SALARY::text LIKE &#8216;2_%_%&#8217; &#8211; 2\ub85c \uc2dc\uc791\ud558\uba70 \ucd5c\uc18c 3\uac1c\uc758 \ubb38\uc790\ub85c \uad6c\uc131\ub41c \uac12\uc744 \uac80\uc0c9\ud568<\/LI><LI>WHERE SALARY::text LIKE &#8216;%2&#8217; &#8211; 2\ub85c \ub05d\ub098\ub294 \ubaa8\ub4e0 \uac12\uc744 \uac80\uc0c9\ud568<\/LI><LI>WHERE SALARY::text LIKE &#8216;_2%3&#8217; &#8211; \ub450\ubc88\uc9f8\ubd80\ud130 2\ub85c \uc2dc\uc791\ud558\uace0 3\uc73c\ub85c \ub05d\ub098\ub294 \ubaa8\ub4e0 \uac12\uc744 \uac80\uc0c9\ud568<\/LI><LI>WHERE SALARY::text LIKE &#8216;2___3&#8217; &#8211; 2\ub85c \uc2dc\uc791\ud558\uace0 3\uc73c\ub85c \ub05d\ub098\uba70 5\uac1c\uc758 \ubb38\uc790\ub85c \uad6c\uc131\ub41c \ubaa8\ub4e0 \uac12\uc744 \uac80\uc0c9\ud568<\/UL><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc774 \uae00\uc758 \uc6d0\ubb38\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. http:\/\/www.tutorialspoint.com\/postgresql\/postgresql_like_clause.htm PostgreSQL\uc740 \uc5d4\ud130\ud504\ub77c\uc774\uc988\uae09\uc758 \ub300\uc6a9\ub7c9\uc758 \ub370\uc774\ud130 \ucc98\ub9ac\uc5d0 \uc801\ud569\ud55c \uc548\uc815\uc801\uc778 DBMS\uc785\ub2c8\ub2e4. \uc774\uae00\uc740 SELECT \ubb38\uc5d0\uc11c LIKE \uac80\uc0c9\uc5d0 \ub300\ud574 \uac04\ub2e8\ud788 \uc815\ub9ac\ud55c \uae00\uc785\ub2c8\ub2e4. LIKE \uac80\uc0c9\uc5d0\uc11c \uc8fc\uc694\ud55c 2\uac00\uc9c0 \ud2b9\uc218\ubb38\uc790\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. Percent Sign(%) : 0\uac1c \uc774\uc0c1\uc758 \ubd88\ud2b9\uc815 \ubb38\uc790\ub97c \ub098\ud0c0\ub0c4Under Score(_) : 1\uac1c\uc758 \ubd88\ud2b9\uc815 \ubb38\uc790\ub97c \ub098\ud0c0\ub0c4 LIKE \uac80\uc0c9\uc758 \uc608\uc640 \uadf8 \uacb0\uacfc\uc5d0 \ub300\ud55c \uc124\uba85\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. WHERE SALARY::text LIKE &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2248\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL\uc758 LIKE \uac80\uc0c9&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2248","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2248"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2248\/revisions"}],"predecessor-version":[{"id":2727,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2248\/revisions\/2727"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2248"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}