{"id":929,"date":"2014-02-17T11:58:06","date_gmt":"2014-02-17T11:58:06","guid":{"rendered":"https:\/\/cowman-chiang.no-ip.org\/wordpress\/?p=929"},"modified":"2019-06-20T10:25:42","modified_gmt":"2019-06-20T02:25:42","slug":"mysql%e6%a8%a1%e7%b3%8a%e6%90%9c%e5%b0%8b%e6%ac%84%e4%bd%8d","status":"publish","type":"post","link":"https:\/\/cowmanchiang.me\/wp\/?p=929","title":{"rendered":"MySQL\u6a21\u7cca\u641c\u5c0b\u6b04\u4f4d"},"content":{"rendered":"<p>\u5728\u4f7f\u7528 select &#8230; where &#8230; like \u7684\u6642\u4faf\u901a\u5e38\u6703\u5c07\u641c\u5c0b\u7684\u95dc\u9375\u5b57\u4ee5&#8221;%&#8221;\u5305\u8d77\u4f86<br \/>\n\u4f46\u662f\u5047\u8a2d\u95dc\u9375\u5b57\u662f\u6b04\u4f4d\u503c\u7684\u8a71? \u8a72\u600e\u9ebc\u5305\u5462?<\/p>\n<p>\u9019\u6642\u5019\u53ef\u4ee5\u4f7f\u7528 concat(&#8216;%&#8217;, \u6b04\u4f4d, &#8216;%&#8217;) \u5c07\u95dc\u9375\u5b57\u6b04\u4f4d\u503c\u7528%\u5305\u8d77\u4f86<br \/>\nEx.<\/p>\n<pre lang=\"sql\">\nSELECT * FROM `nas`, `proxy` where `nas`.`nasname` \n    like concat('%',`proxy`.`proxyserver`,'%') order by `nas`.`id` asc;\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u4f7f\u7528 select &#8230; where &#8230; like \u7684\u6642\u4faf\u901a\u5e38\u6703\u5c07\u641c\u5c0b\u7684\u95dc\u9375\u5b57\u4ee5&#8221;%&#8221;\u5305\u8d77\u4f86 \u4f46\u662f\u5047\u8a2d\u95dc\u9375\u5b57\u662f\u6b04\u4f4d\u503c\u7684\u8a71? \u8a72\u600e\u9ebc\u5305\u5462? \u9019\u6642\u5019\u53ef\u4ee5\u4f7f\u7528 concat(&#8216;%&#8217;, \u6b04\u4f4d, &#8216;%&#8217;) \u5c07\u95dc\u9375\u5b57\u6b04\u4f4d\u503c\u7528%\u5305\u8d77\u4f86 Ex. SELECT * FROM `nas`, `proxy` where `nas`.`nasname` like concat(&#8216;%&#8217;,`proxy`.`proxyserver`,&#8217;%&#8217;) order by `nas`.`id` asc;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62],"tags":[],"class_list":["post-929","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=929"}],"version-history":[{"count":1,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/929\/revisions"}],"predecessor-version":[{"id":2062,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=\/wp\/v2\/posts\/929\/revisions\/2062"}],"wp:attachment":[{"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cowmanchiang.me\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}