{"id":475,"date":"2017-09-11T18:22:43","date_gmt":"2017-09-11T10:22:43","guid":{"rendered":"https:\/\/www.dd-home.top\/?p=475"},"modified":"2017-09-11T18:22:43","modified_gmt":"2017-09-11T10:22:43","slug":"sql-%e6%8a%8a%e8%81%94%e5%90%88%e4%b8%a4%e4%b8%aa%e5%ad%97%e6%ae%b5%e5%8e%bb%e9%87%8d","status":"publish","type":"post","link":"https:\/\/www.dd-home.top\/?p=475","title":{"rendered":"SQL \u628a\u8054\u5408\u4e24\u4e2a\u5b57\u6bb5\u53bb\u91cd"},"content":{"rendered":"<p><!--more--><\/p>\n<p><code class=\"sql keyword\">select<\/code>\u00a0<code class=\"sql plain\">*\u00a0<\/code><code class=\"sql keyword\">from<\/code>\u00a0<code class=\"sql plain\">(<\/code><code class=\"sql keyword\">select<\/code>\u00a0<code class=\"sql plain\">*,\u00a0concat(<\/code><code class=\"sql keyword\">name<\/code><code class=\"sql plain\">,code)\u00a0<\/code><code class=\"sql keyword\">as<\/code>\u00a0<code class=\"sql plain\">__f\u00a0<\/code><code class=\"sql keyword\">from<\/code>\u00a0<code class=\"sql plain\">test\u00a0<\/code><code class=\"sql keyword\">order<\/code>\u00a0<code class=\"sql keyword\">by<\/code>\u00a0<code class=\"sql keyword\">date<\/code>\u00a0<code class=\"sql keyword\">desc<\/code><code class=\"sql plain\">)\u00a0__t\u00a0<\/code><code class=\"sql keyword\">group<\/code>\u00a0<code class=\"sql keyword\">by<\/code>\u00a0<code class=\"sql plain\">__f;<\/code><\/p>\n<p>&nbsp;<\/p>\n<p><code>SELECTSELECT *FROM ( SELECT f.`\u5546\u54c1\u540d`, f.`\u89c4\u683c`, r.`\u4ea7\u5730`, concat( f.`\u5546\u54c1\u540d`, f.`\u89c4\u683c`, r.`\u4ea7\u5730` ) AS __f FROM FIRST AS f LEFT JOIN results r ON ( ( f.\u751f\u4ea7\u4f01\u4e1a LIKE CONCAT('%', r.`\u4ea7\u5730`, '%') #OR r.`\u4ea7\u5730` LIKE CONCAT('%', f.\u751f\u4ea7\u4f01\u4e1a, '%') ) AND ( f.`\u836f\u54c1\u540d\u79f0` LIKE CONCAT('%', r.`\u540d\u79f0`, '%') #OR r.`\u540d\u79f0` LIKE CONCAT('%',f.`\u836f\u54c1\u540d\u79f0` , '%') ) ) WHERE f.`\u5546\u54c1\u540d` != '\u65e0' AND r.`\u4ea7\u5730` != '' ) __tGROUP BY __f;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[31],"tags":[],"class_list":["post-475","post","type-post","status-publish","format-standard","hentry","category-sql"],"_links":{"self":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/475","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=475"}],"version-history":[{"count":0,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/475\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=475"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=475"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=475"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}