{"id":473,"date":"2017-09-11T18:19:42","date_gmt":"2017-09-11T10:19:42","guid":{"rendered":"https:\/\/www.dd-home.top\/?p=473"},"modified":"2017-09-11T18:19:42","modified_gmt":"2017-09-11T10:19:42","slug":"mysql-%e4%b8%a4%e5%bc%a0%e8%a1%a8%e8%81%94%e5%90%88%e6%9f%a5%e8%af%a2%e6%97%b6%e4%b8%80%e4%b8%aa%e5%ad%97%e6%ae%b5%e5%9c%a8%e5%8f%a6%e4%b8%80%e5%bc%a0%e8%a1%a8%e4%b8%ad%e6%a8%a1%e7%b3%8a%e5%8c%b9","status":"publish","type":"post","link":"https:\/\/www.dd-home.top\/?p=473","title":{"rendered":"MySql \u4e24\u5f20\u8868\u8054\u5408\u67e5\u8be2\u65f6\u4e00\u4e2a\u5b57\u6bb5\u5728\u53e6\u4e00\u5f20\u8868\u4e2d\u6a21\u7cca\u5339\u914d"},"content":{"rendered":"<p><!--more--><\/p>\n<p><a href=\"https:\/\/stackoverflow.com\/questions\/4935188\/using-left-join-and-like-mysql\">stackoverflow<\/a><\/p>\n<pre class=\"lang-sql prettyprint prettyprinted\"><span style=\"font-family: verdana, geneva, sans-serif;\"><code><span class=\"kwd\">select<\/span><span class=\"pln\"> tasks<\/span><span class=\"pun\">.<\/span><span class=\"pln\">name \n<\/span><span class=\"kwd\">from<\/span><span class=\"pln\"> users <\/span><span class=\"kwd\">left<\/span> <span class=\"kwd\">join<\/span><span class=\"pln\"> tasks <\/span><span class=\"kwd\">on<\/span><span class=\"pln\"> users<\/span><span class=\"pun\">.<\/span><span class=\"pln\">specialty <\/span><span class=\"kwd\">LIKE<\/span><span class=\"pln\"> CONCAT<\/span><span class=\"pun\">(<\/span><span class=\"str\">'%'<\/span><span class=\"pun\">,<\/span><span class=\"pln\">tasks<\/span><span class=\"pun\">.<\/span><span class=\"pln\">tags<\/span><span class=\"pun\">,<\/span><span class=\"str\">'%'<\/span><span class=\"pun\">)<\/span> \n<span class=\"kwd\">where<\/span><span class=\"pln\"> users<\/span><span class=\"pun\">.<\/span><span class=\"pln\">username <\/span><span class=\"pun\">=<\/span> <span class=\"str\">'JinkX'<\/span><\/code><\/span><\/pre>\n<pre class=\"lang-sql prettyprint prettyprinted\"><code><span class=\"kwd\">select<\/span><span class=\"pln\"> tasks<\/span><span class=\"pun\">.<\/span><span class=\"pln\">name \n<\/span><span class=\"kwd\">from<\/span><span class=\"pln\"> users <\/span><span class=\"kwd\">left<\/span> <span class=\"kwd\">join<\/span><span class=\"pln\"> tasks <\/span><span class=\"kwd\">on<\/span><span class=\"pln\"> users<\/span><span class=\"pun\">.<\/span><span class=\"pln\">specialty REGEXP CONCAT<\/span><span class=\"pun\">(<\/span><span class=\"str\">'(^|,) ?'<\/span><span class=\"pun\">,<\/span><span class=\"pln\">tasks<\/span><span class=\"pun\">.<\/span><span class=\"pln\">tags<\/span><span class=\"pun\">,<\/span><span class=\"str\">' ?($|,)'<\/span><span class=\"pun\">)<\/span> \n<span class=\"kwd\">where<\/span><span class=\"pln\"> users<\/span><span class=\"pun\">.<\/span><span class=\"pln\">username <\/span><span class=\"pun\">=<\/span> <span class=\"str\">'JinkX'<\/span><\/code><\/pre>\n<pre class=\"lang-sql prettyprint prettyprinted\"><code><span class=\"pln\">FIND_IN_SET<\/span><span class=\"pun\">(<\/span><span class=\"pln\">task<\/span><span class=\"pun\">.<\/span><span class=\"pln\">tags<\/span><span class=\"pun\">,<\/span><span class=\"pln\">users<\/span><span class=\"pun\">.<\/span><span class=\"pln\">specialty<\/span><span class=\"pun\">)<\/span><\/code><\/pre>\n<p>&nbsp;<\/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,4],"tags":[52,54],"class_list":["post-473","post","type-post","status-publish","format-standard","hentry","category-sql","category-4","tag-mysql","tag-sql"],"_links":{"self":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/473","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=473"}],"version-history":[{"count":0,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=\/wp\/v2\/posts\/473\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=473"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=473"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dd-home.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}