{"id":1111,"date":"2019-01-31T14:16:17","date_gmt":"2019-01-31T06:16:17","guid":{"rendered":"http:\/\/van-yzt.com\/?p=1111"},"modified":"2019-01-31T14:16:17","modified_gmt":"2019-01-31T06:16:17","slug":"%e6%8c%89%e7%85%a7%e5%85%a5%e5%8f%82%e6%8e%92%e5%ba%8f","status":"publish","type":"post","link":"https:\/\/huzi-baozi.com\/?p=1111","title":{"rendered":"\u6309\u7167\u5165\u53c2\u6392\u5e8f"},"content":{"rendered":"<pre><code class=\"language-sql\">select * from users where extern_uid in ('24311', '169942', '157193', '103420', '183078') order by instr(',24311,169942,157193,103420,183078,', concat(',', extern_uid, ','));\n<\/code><\/pre>\n<p>\u539f\u59cbSQL\uff0c\u7528instr\uff1b<\/p>\n<pre><code class=\"language-java\">public static String getOrderByInstr(String value, String field) {\u2028    return String.format(&quot;INSTR(',%s,', CONCAT(',', %s, ','))&quot;, value, field);\u2028}\n<\/code><\/pre>\n<p>\u5728java\u4e2d\u5c01\u88c5\u6210\u4e00\u4e2a\u65b9\u6cd5\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>select * from users where extern_uid in (&#8216;24311&#8217;, &#8216;169942&#8217;, &#8216;157193&#8217;, &#8216;103420&#8217;, &#8216;183078&#8217;) order by instr(&#8216;,24311,169942,157193,103420,183078,&#8217;, concat(&#8216;,&#8217;, extern_uid, &#8216;,&#8217;)); \u539f\u59cbSQL\uff0c\u7528instr\uff1b public static String getOrderByInstr(String value, String field) {\u2028 return String.format(&quot;INSTR(&#8216;,%s,&#8217;, CONCAT(&#8216;,&#8217;, %s, &#8216;,&#8217;))&quot;, value, field);\u2028} \u5728java\u4e2d\u5c01\u88c5\u6210\u4e00\u4e2a\u65b9\u6cd5\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1111","post","type-post","status-publish","format-standard","hentry","category-snippet"],"_links":{"self":[{"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=\/wp\/v2\/posts\/1111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1111"}],"version-history":[{"count":1,"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=\/wp\/v2\/posts\/1111\/revisions"}],"predecessor-version":[{"id":1112,"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=\/wp\/v2\/posts\/1111\/revisions\/1112"}],"wp:attachment":[{"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/huzi-baozi.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}