{"id":4118,"date":"2023-02-07T14:40:27","date_gmt":"2023-02-07T06:40:27","guid":{"rendered":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=4118"},"modified":"2023-02-07T14:40:53","modified_gmt":"2023-02-07T06:40:53","slug":"chatgpt%e6%b3%a8%e5%86%8c%e4%bd%93%e9%aa%8c","status":"publish","type":"post","link":"https:\/\/www.zeroheart.xyz\/wordpress\/?p=4118","title":{"rendered":"chatgpt\u6ce8\u518c\u4f53\u9a8c"},"content":{"rendered":"\n<p><a href=\"https:\/\/chat.openai.com\/chat\">Java QuickSort Algorithm (openai.com)<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>mysql\u4e2d\uff0c\u6709\u5f20\u8868A\u6709\u5b57\u6bb5\u5047\u8bbe\u53ebuserIds\uff0c\u5b58\u7684\u662f\u7528\u6237id\u7684\u5217\u8868\uff0c\u5982 1, 12, 13 select a.* from A a where a.userIds like &#8216;%1%&#8217;\uff0c\u4f1a\u628a\u542b12\uff0c13\u7684\u4e5f\u67e5\u51fa\u6765\uff0c\u6709\u4ec0\u4e48\u597d\u7684\u65b9\u6cd5\u5417<\/p>\n\n\n\n<p>\u5982\u679c\u8981\u907f\u514d\u4f7f\u7528 <code>LIKE<\/code> \u8bed\u53e5\u5e26\u6765\u7684\u95ee\u9898\uff0c\u53ef\u4ee5\u4f7f\u7528\u5982\u4e0b\u89e3\u51b3\u65b9\u6848\uff1a<\/p>\n\n\n\n<ol>\n<li>\u5c06 <code>userIds<\/code> \u5217\u62c6\u5206\u6210\u591a\u884c\uff0c\u6bcf\u884c\u5bf9\u5e94\u4e00\u4e2a\u7528\u6237 ID\uff0c\u5e76\u5efa\u7acb\u65b0\u8868\u5b58\u50a8\u8fd9\u4e9b\u6570\u636e\u3002<\/li>\n\n\n\n<li>\u5728\u65b0\u8868\u4e2d\u67e5\u8be2\u5339\u914d\u7684\u7528\u6237 ID\u3002<\/li>\n\n\n\n<li>\u5c06\u7ed3\u679c\u5408\u5e76\u5230\u539f\u59cb\u8868\u4e2d\u3002<\/li>\n<\/ol>\n\n\n\n<p>\u4ee5\u4e0b\u662f\u62c6\u5206\u540e\u7684\u8868\u7ed3\u6784\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlCopy code<code>Table A_UserIds\n+----+-------+\n| id | userId|\n+----+-------+\n|  1 |     1 |\n|  2 |    12 |\n|  3 |    13 |\n+----+-------+\n<\/code><\/pre>\n\n\n\n<p>\u7136\u540e\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5\u67e5\u8be2\u76f8\u5173\u6570\u636e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>SELECT a.*\nFROM A a\nJOIN A_UserIds au\nON a.id = au.id\nWHERE au.userId = 1;\n<\/code><\/pre>\n\n\n\n<p>\u8be5\u8bed\u53e5\u5c06\u53ea\u67e5\u8be2\u542b\u6709\u7528\u6237 ID \u4e3a 1 \u7684\u884c\uff0c\u800c\u4e0d\u4f1a\u67e5\u8be2\u5176\u4ed6\u7528\u6237 ID\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>\u5982\u679c\u4e0d\u8fdb\u884c\u62c6\u5206\uff0c\u6709\u529e\u6cd5\u67e5\u8be2\u5417<\/p>\n\n\n\n<p>\u5982\u679c\u4e0d\u62c6\u5206 <code>userIds<\/code> \u5217\uff0c\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u8bed\u53e5\u67e5\u8be2\u76f8\u5173\u6570\u636e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>SELECT a.*\nFROM A a\nWHERE concat(',', a.userIds, ',') like '%,1,%';\n<\/code><\/pre>\n\n\n\n<p>\u8be5\u8bed\u53e5\u901a\u8fc7\u5728 <code>userIds<\/code> \u5217\u7684\u4e24\u4fa7\u6dfb\u52a0\u9017\u53f7\uff0c\u786e\u4fdd\u5339\u914d\u53ea\u5728\u5355\u72ec\u7684\u7528\u6237 ID \u4e0a\u8fdb\u884c\uff0c\u800c\u4e0d\u4f1a\u5bf9\u5176\u4ed6\u7528\u6237 ID \u8fdb\u884c\u5339\u914d\u3002<\/p>\n\n\n\n<p>\u5982\u679c\u60a8\u4f7f\u7528\u7684\u662f MySQL 8.0 \u6216\u66f4\u9ad8\u7248\u672c\uff0c\u60a8\u8fd8\u53ef\u4ee5\u4f7f\u7528\u6b63\u5219\u8868\u8fbe\u5f0f\u8fdb\u884c\u67e5\u8be2\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><code>SELECT a.*\nFROM A a\nWHERE a.userIds regexp '[[:&lt;:]]1[[:>:]]';\n<\/code><\/pre>\n\n\n\n<p>\u8be5\u8bed\u53e5\u4ec5\u8fd4\u56de\u4e0e\u6307\u5b9a\u7684\u7528\u6237 ID \u5339\u914d\u7684\u884c\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Java QuickSort Algorithm (openai.com) mysql\u4e2d\uff0c\u6709\u5f20\u8868A\u6709\u5b57\u6bb5\u5047\u8bbe\u53eb [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4118"}],"collection":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4118"}],"version-history":[{"count":3,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4118\/revisions"}],"predecessor-version":[{"id":4121,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/4118\/revisions\/4121"}],"wp:attachment":[{"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zeroheart.xyz\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}