{"id":340,"date":"2023-09-16T10:44:56","date_gmt":"2023-09-16T02:44:56","guid":{"rendered":""},"modified":"2023-09-16T15:50:11","modified_gmt":"2023-09-16T07:50:11","slug":"sql%e8%af%ad%e5%8f%a5%ef%bc%9a%e6%a0%b9%e6%8d%ae%e9%80%97%e5%8f%b7%e6%88%aa%e5%8f%96%e5%ad%97%e7%ac%a6%e4%b8%b2","status":"publish","type":"post","link":"https:\/\/mushiming.com\/340.html","title":{"rendered":"SQL\u8bed\u53e5\uff1a\u6839\u636e\u9017\u53f7\u622a\u53d6\u5b57\u7b26\u4e32"},"content":{"rendered":"<p>\u6570\u636e\u8868\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.mushiming.top\/app\/common_img\/93d1884558fb471bb05f98b60970c267.png\" =\"\" =\"\" alt=\"SQL\u8bed\u53e5\uff1a\u6839\u636e\u9017\u53f7\u622a\u53d6\u5b57\u7b26\u4e32 (https:\/\/mushiming.com\/) \u6280\u672f\u535a\u5ba2 \u7b2c1\u5f20\" title=\"SQL\u8bed\u53e5\uff1a\u6839\u636e\u9017\u53f7\u622a\u53d6\u5b57\u7b26\u4e32 \u6280\u672f\u535a\u5ba2 \u7b2c1\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<p>1.\u622a\u53d6\u9017\u53f7\u524d\u7684\u5b57\u7b26\u4e32<\/p>\n<p>SELECT CASE WHEN a LIKE '%,%' THEN<\/p>\n<p>LEFT ( a, LOCATE( ',', a )- 1 ) ELSE a<\/p>\n<p>END \u7ecf\u5ea6<\/p>\n<p>FROM abc<\/p>\n<p>\u5b57\u6bb5\u540d\uff1aa<\/p>\n<p>\u8868\u540d\uff1aabc<\/p>\n<p>\u622a\u53d6\u540e\u5b57\u6bb5\u540d\uff1a<\/p>\n<p>\u67e5\u8be2\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.mushiming.top\/app\/common_img\/f6d81f0c47564f499a5154e1924f70d6.png\" =\"\" =\"\" alt=\"SQL\u8bed\u53e5\uff1a\u6839\u636e\u9017\u53f7\u622a\u53d6\u5b57\u7b26\u4e32 (https:\/\/mushiming.com\/) \u6280\u672f\u535a\u5ba2 \u7b2c2\u5f20\" title=\"SQL\u8bed\u53e5\uff1a\u6839\u636e\u9017\u53f7\u622a\u53d6\u5b57\u7b26\u4e32 \u6280\u672f\u535a\u5ba2 \u7b2c2\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p>\n<\/p>\n<p>2.\u622a\u53d6\u9017\u53f7\u540e\u9762\u7684\u5b57\u7b26\u4e32<\/p>\n<p>SELECT CASE WHEN a LIKE '%,%' THEN<\/p>\n<p>RIGHT ( a, LOCATE( ',', a )-2 ) ELSE a<\/p>\n<p>END \u7eac\u5ea6<\/p>\n<p>FROM abc<\/p>\n<p>\u5b57\u6bb5\u540d\uff1aa<\/p>\n<p>\u8868\u540d\uff1aabc<\/p>\n<p>\u622a\u53d6\u540e\u5b57\u6bb5\u540d\uff1a\u7eac\u5ea6<\/p>\n<p>\u67e5\u8be2\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.mushiming.top\/app\/common_img\/05a19cec9eb84659a971130c2bfa69b3.png\" =\"\" =\"\" alt=\"SQL\u8bed\u53e5\uff1a\u6839\u636e\u9017\u53f7\u622a\u53d6\u5b57\u7b26\u4e32 (https:\/\/mushiming.com\/) \u6280\u672f\u535a\u5ba2 \u7b2c3\u5f20\" title=\"SQL\u8bed\u53e5\uff1a\u6839\u636e\u9017\u53f7\u622a\u53d6\u5b57\u7b26\u4e32 \u6280\u672f\u535a\u5ba2 \u7b2c3\u5f20-\u7a46\u4e16\u660e\u535a\u5ba2\" ><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"\u6570\u636e\u8868\uff1a1.\u622a\u53d6\u9017\u53f7\u524d\u7684\u5b57\u7b26\u4e32SELECTCASEWHENaLIKE'%,%'THENLEFT(a,LOCATE(',',a)-1)ELSEaEND\u7ecf\u5ea6FROMabc\u5b57\u6bb5\u540d\uff1aa\u8868\u540d\uff1aabc...","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[82],"tags":[],"_links":{"self":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/340"}],"collection":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":0,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"wp:attachment":[{"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mushiming.com\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}