{"id":765,"date":"2020-02-18T16:15:32","date_gmt":"2020-02-18T08:15:32","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=765"},"modified":"2020-02-18T16:17:25","modified_gmt":"2020-02-18T08:17:25","slug":"mysql%e4%b8%ad%e4%bd%bf%e7%94%a8replace-regexp%e5%ae%9e%e7%8e%b0%e6%ad%a3%e5%88%99%e6%9b%bf%e6%8d%a2","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=765","title":{"rendered":"mysql\u4e2d\u4f7f\u7528replace regexp\u5b9e\u73b0\u6b63\u5219\u66ff\u6362"},"content":{"rendered":"

mysql\u7684\u6b63\u5219\u5339\u914d\u7528regexp\uff0c\u800c\u66ff\u6362\u5b57\u7b26\u4e32\u7528REPLACE(str,from_str,to_str)<\/p>\n

\u4f8b\u5982
\nUPDATE myTable SET HTML=REPLACE(HTML,'<br>','') WHERE HTML REGEXP '(<br *\/*>\\s*){2,}'<\/code><\/p>\n

\u66f4\u591a\u4f8b\u5b50\u5982\u4e0b\uff1a<\/p>\n

\u4e3a\u4e86\u627e\u51fa\u4ee5\u201cd\u201d\u5f00\u5934\u7684\u540d\u5b57\uff0c\u4f7f\u7528\u201c^\u201d\u5339\u914d\u540d\u5b57\u7684\u5f00\u59cb\uff1a<\/p>\n

SELECT * FROM master_data.md_employee WHERE name REGEXP ‘^d’;<\/p>\n

\u4e3a\u4e86\u627e\u51fa\u4ee5\u201clove\u201d\u7ed3\u5c3e\u7684\u540d\u5b57\uff0c\u4f7f\u7528\u201c$\u201d\u5339\u914d\u540d\u5b57\u7684\u7ed3\u5c3e\uff1a<\/p>\n

SELECT id,name FROM master_data.md_employee WHERE name REGEXP ‘love$’;<\/p>\n

\u4e3a\u4e86\u627e\u51fa\u5305\u542b\u4e00\u4e2a\u201cw\u201d\u7684\u540d\u5b57\uff0c\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\uff1a<\/p>\n

SELECT id,name FROM master_data.md_employee WHERE name REGEXP ‘w’;<\/p>\n

\u4e3a\u4e86\u627e\u51fa\u5305\u542b\u6b63\u597d5\u4e2a\u5b57\u7b26\u7684\u540d\u5b57\uff0c\u4f7f\u7528\u201c^\u201d\u548c\u201c$\u201d\u5339\u914d\u540d\u5b57\u7684\u5f00\u59cb\u548c\u7ed3\u5c3e\uff0c\u548c5\u4e2a\u201c.\u201d\u5b9e\u4f8b\u5728\u4e24\u8005\u4e4b\u95f4\uff1a<\/p>\n

SELECT id,name FROM master_data.md_employee WHERE name REGEXP ‘^…..$’;<\/div>\n
\u6216\u8005\uff1a<\/div>\n
SELECT id,name FROM master_data.md_employee WHERE name REGEXP ‘^.{5}$’;<\/div>\n
<\/div>\n
\u53c2\u8003\u8d44\u6599\uff1a<\/div>\n
\n

MySQL\u4e2d\u4f7f\u7528replace\u3001regexp\u8fdb\u884c\u6b63\u5219\u8868\u8fbe\u5f0f\u66ff\u6362\u7684\u7528\u6cd5\u5206\u6790<\/a><\/h4>\n<\/div>\n

MySQL\u5982\u4f55\u5b9e\u73b0\u6b63\u5219\u67e5\u627e\u66ff\u6362\uff1f<\/a><\/h4>\n","protected":false},"excerpt":{"rendered":"

mysql\u7684\u6b63\u5219\u5339\u914d\u7528regexp\uff0c\u800c\u66ff\u6362\u5b57\u7b26\u4e32\u7528REPLACE(str,from_str,to_str) \u4f8b […]<\/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\/765"}],"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=765"}],"version-history":[{"count":2,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/765\/revisions"}],"predecessor-version":[{"id":767,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/765\/revisions\/767"}],"wp:attachment":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=765"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}