{"id":2099,"date":"2016-04-15T14:55:37","date_gmt":"2016-04-15T05:55:37","guid":{"rendered":"http:\/\/hangunsworld.com\/blog\/?p=2099"},"modified":"2016-04-15T14:57:41","modified_gmt":"2016-04-15T05:57:41","slug":"mysql%ec%97%90%ec%84%9c-%ec%b5%9c%ea%b7%bc-%eb%8d%b0%ec%9d%b4%ed%84%b0-%ec%a1%b0%ed%9a%8c%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/hangunsworld.com\/blog\/2099","title":{"rendered":"MySQL\uc5d0\uc11c \ucd5c\uadfc \ub370\uc774\ud130 \uc870\ud68c\ud558\uae30"},"content":{"rendered":"<p>\ub514\ube44 \uc870\ud68c \uc2dc\uc5d0 \ucd5c\uadfc \ud55c \ub2ec, \ub610\ub294 \ucd5c\uadfc 2\uc8fc \ub3d9\uc548\uc758 \ub370\uc774\ud130\uac00 \ud544\uc694\ud560 \ub54c <code>CURRENT_DATE<\/code>\uc640 <code>INTERVAL<\/code>\uc744 \uc0ac\uc6a9\ud558\uba74 \ud3b8\ud558\ub124\uc694.<\/p>\n<pre lang=\"sql\">SELECT * FROM `table` WHERE `date` > CURRENT_DATE - INTERVAL '1' MONTH;\r\nSELECT * FROM `table` WHERE `date` > CURRENT_DATE - INTERVAL '2' WEEK;\r\nSELECT * FROM `table` WHERE `date` > CURRENT_DATE - INTERVAL '10' DAY;<\/pre>\n<p>\uae30\uac04\ub3c4 \uc6d4, \uc8fc, \ub610\ub294 \uc77c \ub2e8\uc704 \ub4f1\uc73c\ub85c \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub514\ube44 \uc870\ud68c \uc2dc\uc5d0 \ucd5c\uadfc \ud55c \ub2ec, \ub610\ub294 \ucd5c\uadfc 2\uc8fc \ub3d9\uc548\uc758 \ub370\uc774\ud130\uac00 \ud544\uc694\ud560 \ub54c CURRENT_DATE\uc640 INTERVAL\uc744 \uc0ac\uc6a9\ud558\uba74 \ud3b8\ud558\ub124\uc694. SELECT * FROM `table` WHERE `date` > CURRENT_DATE &#8211; INTERVAL &#8216;1&#8217; MONTH; SELECT * FROM `table` WHERE `date` > CURRENT_DATE &#8211; INTERVAL &#8216;2&#8217; WEEK; SELECT * FROM `table` WHERE `date` > CURRENT_DATE &#8211; INTERVAL &#8217;10&#8217; DAY; \uae30\uac04\ub3c4 \uc6d4, [&hellip;]<\/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":[572],"class_list":["post-2099","post","type-post","status-publish","format-standard","hentry","category-serverscript","tag-mysql"],"_links":{"self":[{"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/posts\/2099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/comments?post=2099"}],"version-history":[{"count":0,"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/posts\/2099\/revisions"}],"wp:attachment":[{"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/media?parent=2099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/categories?post=2099"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hangunsworld.com\/blog\/wp-json\/wp\/v2\/tags?post=2099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}