{"id":57,"date":"2018-11-12T20:35:18","date_gmt":"2018-11-12T12:35:18","guid":{"rendered":"http:\/\/www.aymoo.com\/?p=57"},"modified":"2018-11-12T20:35:18","modified_gmt":"2018-11-12T12:35:18","slug":"mysql-%e6%a0%b9%e6%8d%ae%e8%ba%ab%e4%bb%bd%e8%af%81%e5%8f%b7%e8%ae%a1%e7%ae%97%e5%b9%b4%e9%be%84","status":"publish","type":"post","link":"http:\/\/www.aymoo.com\/?p=57","title":{"rendered":"mysql \u6839\u636e\u8eab\u4efd\u8bc1\u53f7\u8ba1\u7b97\u5e74\u9f84"},"content":{"rendered":"<div class=\"sqlOuter\" style=\"color: #444444;\">\n<div class=\"sql-highlight cm-s-default\"><span class=\"cm-keyword\" style=\"color: #770088;\"><a class=\"cm-sql-doc\" style=\"color: #235a81;\" href=\"http:\/\/db01.adt15.cn\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/select.html\" target=\"mysql_doc\">select<\/a><\/span>\u00a0<span class=\"cm-keyword\" style=\"color: #770088;\"><a class=\"cm-sql-doc\" style=\"color: #235a81;\" href=\"http:\/\/db01.adt15.cn\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/control-flow-functions.html#function_if\" target=\"mysql_doc\">if<\/a><\/span>\u00a0((month(now())\u00a0&lt;\u00a0substring(id_number,\u00a0<span class=\"cm-number\" style=\"color: #116644;\">11<\/span>,\u00a0<span class=\"cm-number\" style=\"color: #116644;\">2<\/span>)\u00a0<span class=\"cm-keyword\" style=\"color: #770088;\"><a class=\"cm-sql-doc\" style=\"color: #235a81;\" href=\"http:\/\/db01.adt15.cn\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/logical-operators.html#operator_or\" target=\"mysql_doc\">OR<\/a><\/span>\u00a0(day(now())\u00a0&lt;\u00a0substring(id_number,\u00a0<span class=\"cm-number\" style=\"color: #116644;\">13<\/span>,\u00a0<span class=\"cm-number\" style=\"color: #116644;\">2<\/span>))),\u00a0(<span class=\"cm-builtin\" style=\"color: #3300aa;\"><a class=\"cm-sql-doc\" style=\"color: #235a81;\" href=\"http:\/\/db01.adt15.cn\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/date-and-time-types.html\" target=\"mysql_doc\">year<\/a><\/span>(now())-substring(id_number,\u00a0<span class=\"cm-number\" style=\"color: #116644;\">7<\/span>,<span class=\"cm-number\" style=\"color: #116644;\">4<\/span>)-<span class=\"cm-number\" style=\"color: #116644;\">1<\/span>),\u00a0(<span class=\"cm-builtin\" style=\"color: #3300aa;\"><a class=\"cm-sql-doc\" style=\"color: #235a81;\" href=\"http:\/\/db01.adt15.cn\/url.php?url=https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/date-and-time-types.html\" target=\"mysql_doc\">year<\/a><\/span>(now())-substring(id_number,\u00a0<span class=\"cm-number\" style=\"color: #116644;\">7<\/span>,\u00a0<span class=\"cm-number\" style=\"color: #116644;\">4<\/span>))),\u00a0id_number\u00a0<span class=\"cm-keyword\" style=\"color: #770088;\">from<\/span>\u00a0user<\/div>\n<p>&nbsp;<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>select\u00a0if\u00a0((month(now())\u00a0&lt;\u00a0substring(id_number,\u00a011,\u00a0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts\/57"}],"collection":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=57"}],"version-history":[{"count":1,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions"}],"predecessor-version":[{"id":58,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts\/57\/revisions\/58"}],"wp:attachment":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=57"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=57"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}