{"id":772,"date":"2020-02-26T09:58:13","date_gmt":"2020-02-26T01:58:13","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=772"},"modified":"2020-02-26T09:58:42","modified_gmt":"2020-02-26T01:58:42","slug":"mysql%e4%b8%ad%e5%88%a4%e6%96%ad%e5%ad%97%e6%ae%b5%e6%98%af%e5%90%a6%e5%8c%85%e5%90%ab%e6%95%b0%e5%ad%97%e6%88%96%e8%80%85%e6%98%af%e5%90%a6%e4%b8%ba%e7%ba%af%e6%95%b0%e5%ad%97","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=772","title":{"rendered":"mysql\u4e2d\u5224\u65ad\u5b57\u6bb5\u662f\u5426\u5305\u542b\u6570\u5b57\u6216\u8005\u662f\u5426\u4e3a\u7eaf\u6570\u5b57"},"content":{"rendered":"<ul>\n<li><a href=\"file:\/\/\/D:\/GitRepository\/JavaKnowledgeTree\/SQL\/mysql%E4%B8%AD%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97%E6%88%96%E8%80%85%E6%98%AF%E5%90%A6%E4%B8%BA%E7%BA%AF%E6%95%B0%E5%AD%97.md#%E5%90%84%E7%A7%8D%E5%9C%BA%E6%99%AF\">\u5404\u79cd\u573a\u666f<\/a>\n<ul>\n<li><a href=\"file:\/\/\/D:\/GitRepository\/JavaKnowledgeTree\/SQL\/mysql%E4%B8%AD%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97%E6%88%96%E8%80%85%E6%98%AF%E5%90%A6%E4%B8%BA%E7%BA%AF%E6%95%B0%E5%AD%97.md#%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97\">\u5224\u65ad\u5b57\u6bb5\u662f\u5426\u5305\u542b\u6570\u5b57<\/a><\/li>\n<li><a href=\"file:\/\/\/D:\/GitRepository\/JavaKnowledgeTree\/SQL\/mysql%E4%B8%AD%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97%E6%88%96%E8%80%85%E6%98%AF%E5%90%A6%E4%B8%BA%E7%BA%AF%E6%95%B0%E5%AD%97.md#%E4%BD%BF%E7%94%A8like%E6%A8%A1%E7%B3%8A%E6%9F%A5%E8%AF%A2%E5%8C%85%E5%90%AB%E6%9F%90%E4%B8%AA%E6%95%B0%E5%AD%97\">\u4f7f\u7528like\u6a21\u7cca\u67e5\u8be2\u5305\u542b\u67d0\u4e2a\u6570\u5b57<\/a><\/li>\n<li><a href=\"file:\/\/\/D:\/GitRepository\/JavaKnowledgeTree\/SQL\/mysql%E4%B8%AD%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97%E6%88%96%E8%80%85%E6%98%AF%E5%90%A6%E4%B8%BA%E7%BA%AF%E6%95%B0%E5%AD%97.md#%E4%BD%BF%E7%94%A8mysql%E5%8E%9F%E7%94%9F%E5%87%BD%E6%95%B0find_in_set%E6%9F%A5%E8%AF%A2%E5%8C%85%E5%90%AB%E6%9F%90%E4%B8%AA%E6%95%B0%E5%AD%97\">\u4f7f\u7528mysql\u539f\u751f\u51fd\u6570FIND_IN_SET\u67e5\u8be2\u5305\u542b\u67d0\u4e2a\u6570\u5b57<\/a><\/li>\n<li><a href=\"file:\/\/\/D:\/GitRepository\/JavaKnowledgeTree\/SQL\/mysql%E4%B8%AD%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97%E6%88%96%E8%80%85%E6%98%AF%E5%90%A6%E4%B8%BA%E7%BA%AF%E6%95%B0%E5%AD%97.md#%E4%BD%BF%E7%94%A8regexp%E6%AD%A3%E5%88%99%E5%8C%B9%E9%85%8D%E7%BA%AF%E6%95%B0%E5%AD%97\">\u4f7f\u7528regexp\u6b63\u5219\u5339\u914d\u7eaf\u6570\u5b57<\/a><\/li>\n<li><a href=\"file:\/\/\/D:\/GitRepository\/JavaKnowledgeTree\/SQL\/mysql%E4%B8%AD%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97%E6%88%96%E8%80%85%E6%98%AF%E5%90%A6%E4%B8%BA%E7%BA%AF%E6%95%B0%E5%AD%97.md#%E4%BD%BF%E7%94%A8regexp%E6%AD%A3%E5%88%99%E5%8C%B9%E9%85%8D%E5%AD%97%E6%AE%B5%E5%80%BC%E4%B8%8D%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97\">\u4f7f\u7528regexp\u6b63\u5219\u5339\u914d\u5b57\u6bb5\u503c\u4e0d\u5305\u542b\u6570\u5b57<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"file:\/\/\/D:\/GitRepository\/JavaKnowledgeTree\/SQL\/mysql%E4%B8%AD%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97%E6%88%96%E8%80%85%E6%98%AF%E5%90%A6%E4%B8%BA%E7%BA%AF%E6%95%B0%E5%AD%97.md#%E5%8F%82%E8%80%83%E8%B5%84%E6%96%99\">\u53c2\u8003\u8d44\u6599<\/a><\/li>\n<\/ul>\n<h1 id=\"%E5%90%84%E7%A7%8D%E5%9C%BA%E6%99%AF\" class=\"mume-header\">\u5404\u79cd\u573a\u666f<\/h1>\n<h2 id=\"%E5%88%A4%E6%96%AD%E5%AD%97%E6%AE%B5%E6%98%AF%E5%90%A6%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97\" class=\"mume-header\">\u5224\u65ad\u5b57\u6bb5\u662f\u5426\u5305\u542b\u6570\u5b57<\/h2>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>select name from text where name regex '[0-9]'\r\n<\/code><\/pre>\n<h2 id=\"%E4%BD%BF%E7%94%A8like%E6%A8%A1%E7%B3%8A%E6%9F%A5%E8%AF%A2%E5%8C%85%E5%90%AB%E6%9F%90%E4%B8%AA%E6%95%B0%E5%AD%97\" class=\"mume-header\">\u4f7f\u7528like\u6a21\u7cca\u67e5\u8be2\u5305\u542b\u67d0\u4e2a\u6570\u5b57<\/h2>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>select * from text where name like '%1%'\r\n<\/code><\/pre>\n<p>\u53ef\u80fd\u4f1a\u7b5b\u51fa\u5404\u79cd\u4e0d\u9002\u6211\u4eec\u60f3\u8981\u7684\uff0c\u6bd4\u5982\u5305\u542b\u201c10\u201d\u7684\u5b57\u6bb5\u4e5f\u4f1a\u7b5b\u9009\u51fa\u3002<!--more--><\/p>\n<h2 id=\"%E4%BD%BF%E7%94%A8mysql%E5%8E%9F%E7%94%9F%E5%87%BD%E6%95%B0find_in_set%E6%9F%A5%E8%AF%A2%E5%8C%85%E5%90%AB%E6%9F%90%E4%B8%AA%E6%95%B0%E5%AD%97\" class=\"mume-header\">\u4f7f\u7528mysql\u539f\u751f\u51fd\u6570FIND_IN_SET\u67e5\u8be2\u5305\u542b\u67d0\u4e2a\u6570\u5b57<\/h2>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>select * from text where find_in_set(1,name)\r\n<\/code><\/pre>\n<p>\u6bd4like\u66f4\u7cbe\u786e\u4e00\u4e0b\u3002<\/p>\n<h2 id=\"%E4%BD%BF%E7%94%A8regexp%E6%AD%A3%E5%88%99%E5%8C%B9%E9%85%8D%E7%BA%AF%E6%95%B0%E5%AD%97\" class=\"mume-header\">\u4f7f\u7528regexp\u6b63\u5219\u5339\u914d\u7eaf\u6570\u5b57<\/h2>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>select * from text where (name REGEXP '[^0-9.]')=0;\r\n<\/code><\/pre>\n<p>\u4f8b\u5982\uff1a<br \/>\n\u5f53 SELECT &#8220;666&#8221; REGEXP &#8216;[^0-9.]&#8217; \u7ed3\u679c\u4e3a 0 ,\u4ee3\u8868\u4e3a\u7eaf\u6570\u5b57<br \/>\n\u5f53 SELECT &#8220;6hhhhh&#8221; REGEXP &#8216;[^0-9.]&#8217; \u65f6, \u7ed3\u679c\u4e3a1 ,\u4ee3\u8868\u4e0d\u4e3a\u7eaf\u6570\u5b57<\/p>\n<h2 id=\"%E4%BD%BF%E7%94%A8regexp%E6%AD%A3%E5%88%99%E5%8C%B9%E9%85%8D%E5%AD%97%E6%AE%B5%E5%80%BC%E4%B8%8D%E5%8C%85%E5%90%AB%E6%95%B0%E5%AD%97\" class=\"mume-header\">\u4f7f\u7528regexp\u6b63\u5219\u5339\u914d\u5b57\u6bb5\u503c\u4e0d\u5305\u542b\u6570\u5b57<\/h2>\n<pre class=\"language-\" data-role=\"codeBlock\" data-info=\"\"><code>select * from text where name NOT REGEXP '[0-9]+';\r\n<\/code><\/pre>\n<h1 id=\"%E5%8F%82%E8%80%83%E8%B5%84%E6%96%99\" class=\"mume-header\">\u53c2\u8003\u8d44\u6599<\/h1>\n<ul>\n<li><a href=\"https:\/\/blog.csdn.net\/u010173095\/article\/details\/79525754\">mysql \u5339\u914d\u5b57\u7b26\u4e32\u4e2d\u662f\u5426\u5305\u542b\u6570\u5b57<\/a><\/li>\n<li><a href=\"https:\/\/blog.csdn.net\/nookl\/article\/details\/80795956\">\u4f7f\u7528MYSQL\u67e5\u8be2\u6570\u636e\u8868\u4e2d\u67d0\u4e2a\u5b57\u6bb5\u5305\u542b\u67d0\u4e2a\u6570\u503c<\/a><\/li>\n<li><a href=\"https:\/\/blog.csdn.net\/loongshawn\/article\/details\/78611636\">MySQL\u51fd\u6570find_in_set\u4ecb\u7ecd<\/a><\/li>\n<li><a href=\"https:\/\/blog.csdn.net\/qq_26975307\/article\/details\/84775809\">MySQL\u67e5\u8be2\u5b57\u6bb5\u4e3a\u7eaf\u6570\u5b57\u7684\u6570\u636e<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u5404\u79cd\u573a\u666f \u5224\u65ad\u5b57\u6bb5\u662f\u5426\u5305\u542b\u6570\u5b57 \u4f7f\u7528like\u6a21\u7cca\u67e5\u8be2\u5305\u542b\u67d0\u4e2a\u6570\u5b57 \u4f7f\u7528mysql\u539f\u751f\u51fd\u6570FIND_IN_SET <a href='http:\/\/prayerlaputa.com\/?p=772' class='excerpt-more'>[&#8230;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[63],"tags":[64],"_links":{"self":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/772"}],"collection":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=772"}],"version-history":[{"count":2,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/772\/revisions"}],"predecessor-version":[{"id":774,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/772\/revisions\/774"}],"wp:attachment":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=772"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}