{"id":164,"date":"2019-12-12T14:22:50","date_gmt":"2019-12-12T06:22:50","guid":{"rendered":"http:\/\/www.cgh0610.cn\/?p=164"},"modified":"2019-12-12T14:22:50","modified_gmt":"2019-12-12T06:22:50","slug":"mysql%e6%9f%a5%e8%af%a2%e6%9f%90%e4%b8%aa%e5%ad%97%e6%ae%b5%e5%8c%85%e5%90%ab%e6%9f%90%e4%b8%aa%e5%80%bc","status":"publish","type":"post","link":"https:\/\/www.cgh0610.cn\/?p=164","title":{"rendered":"Mysql\u67e5\u8be2\u67d0\u4e2a\u5b57\u6bb5\u5305\u542b\u67d0\u4e2a\u503c"},"content":{"rendered":"<p>\u67e5\u8be2\u5b57\u6bb5\u67d0\u4e00\u5b57\u6bb5\u4e2d\u5305\u542b\u67d0\u4e00ID\u7684\u8bb0\u5f55\u6211\u4eec\u53ef\u4ee5\u7528\u4ee5\u4e0b\u7684\u65b9\u6cd5\uff1a<\/p>\n<p>\u9996\u5148\u521b\u5efa\u8868\uff1a<\/p>\n<pre><code class=\"language-sql line-numbers\">CREATE TABLE users(id int(6) NOT NULL AUTO_INCREMENT,PRIMARY KEY (id),name VARCHAR(20) NOT NULL,limits VARCHAR(50) NOT NULL);\n<\/code><\/pre>\n<p>\u6dfb\u52a0\u6570\u636e\uff1a<\/p>\n<pre><code class=\"language-sql line-numbers\">1\u3001 INSERT INTO users(name, limits) VALUES('\u5c0f\u5f20','1,2,12');\n\n2\u3001 INSERT INTO users(name, limits) VALUES('\u5c0f\u738b','11,22,32');\n<\/code><\/pre>\n<p>\u5982\u4f55\u67e5\u8be2\u51falimits\u5b57\u6bb5\u4e2d\u542b\u6709ID=2\u7684\u8bb0\u5f55\u5462\uff0c\u6211\u4eec\u53ef\u4ee5\u7528\u4ee5\u4e0b\u7684\u65b9\u6cd5\uff1a<\/p>\n<p>\u7b2c\u4e00\u79cd\u65b9\u6cd5\uff1a<\/p>\n<pre><code class=\"language-sql line-numbers\">SELECT * FROM users WHERE limits like \"%2%\";\n<\/code><\/pre>\n<p>\u6267\u884c\u540e\u60a8\u4f1a\u53d1\u73b0\u4e24\u6761\u6570\u636e\u90fd\u88ab\u67e5\u8be2\u4e86\u51fa\u6765\uff0c\u800c\u7b2c2\u6761\u6570\u636e\u662f\u6211\u4eec\u4e0d\u60f3\u8981\u7684\uff0c\u6240\u4ee5\u6211\u4eec\u9700\u8981\u5bf9\u67e5\u8be2\u8fdb\u884c\u4f18\u5316\uff0c\u8003\u8651\u6240\u6709\u60c5\u51b5\uff1a<\/p>\n<pre><code class=\"language-sql line-numbers\">SELECT * FROM users WHERE limits like \"%,2,%,\" or \"2,%\" or \"%,2\" or \"2\";\n<\/code><\/pre>\n<p>\u53e6\u4e00\u79cd\u65b9\u6cd5\u5c31\u662f\u5229\u7528mysql \u5b57\u7b26\u4e32\u51fd\u6570 find_in_set()\u3002<\/p>\n<p>\u7b2c\u4e8c\u79cd\u65b9\u6cd5\uff1a<br \/>\n<code>SELECT * FROM users WHERE find_in_set('2', limits);<\/code><\/p>\n<p>\u8fd9\u4e00\u53e5\u5373\u53ef\u89e3\u51b3\u3002\u3002<\/p>\n<p>\u53e6\u9700\u6ce8\u610f\uff1amysql\u5b57\u7b26\u4e32\u51fd\u6570 find_in_set(str1,str2)\u51fd\u6570\u662f\u8fd4\u56destr2\u4e2dstr1\u6240\u5728\u7684\u4f4d\u7f6e\u7d22\u5f15\uff0cstr2\u5fc5\u987b\u4ee5&#8221;,&#8221;\u5206\u5272\u5f00\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u8be2\u5b57\u6bb5\u67d0\u4e00\u5b57\u6bb5\u4e2d\u5305\u542b\u67d0\u4e00ID\u7684\u8bb0\u5f55\u6211\u4eec\u53ef\u4ee5\u7528\u4ee5\u4e0b\u7684\u65b9\u6cd5\uff1a \u9996\u5148\u521b\u5efa\u8868\uff1a CREATE TABLE users &hellip; <a href=\"https:\/\/www.cgh0610.cn\/?p=164\" class=\"more-link\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">Mysql\u67e5\u8be2\u67d0\u4e2a\u5b57\u6bb5\u5305\u542b\u67d0\u4e2a\u503c<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"aside","meta":[],"categories":[39,12],"tags":[28],"_links":{"self":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/164"}],"collection":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=164"}],"version-history":[{"count":2,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/164\/revisions"}],"predecessor-version":[{"id":166,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=\/wp\/v2\/posts\/164\/revisions\/166"}],"wp:attachment":[{"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cgh0610.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}