{"id":2137,"date":"2018-12-08T23:04:22","date_gmt":"2018-12-08T15:04:22","guid":{"rendered":"https:\/\/www.baishitou.cn\/?p=2137"},"modified":"2018-12-08T23:04:22","modified_gmt":"2018-12-08T15:04:22","slug":"%e7%bb%87%e6%a2%a6dedecms%e7%94%a8sql%e5%91%bd%e4%bb%a4%e6%89%b9%e9%87%8f%e4%bf%ae%e6%94%b9%e6%96%87%e7%ab%a0%e5%86%85%e5%ae%b9%e5%92%8c%e7%bc%a9%e7%95%a5%e5%9b%be%e8%b7%af%e5%be%84","status":"publish","type":"post","link":"https:\/\/www.baishitou.cn\/2137.html","title":{"rendered":"\u7ec7\u68a6DEDECMS\u7528SQL\u547d\u4ee4\u6279\u91cf\u4fee\u6539\u6587\u7ae0\u5185\u5bb9\u548c\u7f29\u7565\u56fe\u8def\u5f84"},"content":{"rendered":"<h1>\u7ec7\u68a6DEDECMS\u7528SQL\u547d\u4ee4\u6279\u91cf\u4fee\u6539\u6587\u7ae0\u5185\u5bb9\u548c\u7f29\u7565\u56fe\u8def\u5f84<\/h1>\n<p>\u8fdb\u5165\u540e\u53f0\u7cfb\u7edf\u8bbe\u7f6e-SQL\u547d\u4ee4\u884c\u5de5\u5177<\/p>\n<h2>1.\u66f4\u6539\u6587\u7ae0\u4e2d\u7684\u5185\u5bb9SQL\u547d\u4ee4\uff1a<\/h2>\n<div>\n<pre class=\"pure-highlightjs\"><code class=\"\">update dede_addonarticle set body=replace(body,'\u539f\u6765\u7684\u5b57\u7b26\u2019,'\u66ff\u6362\u540e\u7684\u5b57\u7b26\u2019)<\/code><\/pre>\n<\/div>\n<h2>2.\u66f4\u6539\u7f29\u7565\u56fe\u76ee\u5f55SQL\u547d\u4ee4\uff1a<\/h2>\n<div>\n<pre class=\"pure-highlightjs\"><code class=\"\">update\u00a0dede_archives set litpic=replace(litpic,'\u539f\u6765\u7684\u5b57\u7b26\u2019,'\u66ff\u6362\u540e\u7684\u5b57\u7b26\u2019)<\/code><\/pre>\n<\/div>\n<p><a href=\"https:\/\/www.baishitou.cn\/wp-content\/uploads\/2018\/12\/bst20181208230251.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2138\" src=\"https:\/\/www.baishitou.cn\/wp-content\/uploads\/2018\/12\/bst20181208230251.jpg\" alt=\"\" width=\"730\" height=\"418\" srcset=\"https:\/\/www.baishitou.cn\/wp-content\/uploads\/2018\/12\/bst20181208230251.jpg 730w, https:\/\/www.baishitou.cn\/wp-content\/uploads\/2018\/12\/bst20181208230251-300x172.jpg 300w\" sizes=\"auto, (max-width: 730px) 100vw, 730px\" \/><\/a><\/p>\n<p>\u4e0a\u56fe\u5c31\u662f\u6267\u884c\u4e86\u66f4\u6539\u7f29\u7565\u8def\u5f84\u7684\u547d\u4ee4\uff0c\u628a\u7f29\u7565\u56fe\u8def\u5f84\u4e2d\u7684http:\/\/www.com\u5168\u90e8\u5220\u9664<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7ec7\u68a6DEDECMS\u7528SQL\u547d\u4ee4\u6279\u91cf\u4fee\u6539\u6587\u7ae0\u5185\u5bb9\u548c\u7f29\u7565\u56fe\u8def\u5f84 \u8fdb\u5165\u540e\u53f0\u7cfb\u7edf\u8bbe\u7f6e-SQL\u547d\u4ee4\u884c\u5de5\u5177 1.\u66f4\u6539\u6587\u7ae0\u4e2d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[43,321,407,180,718],"class_list":["post-2137","post","type-post","status-publish","format-standard","hentry","category-web","tag-dedecms","tag-sql","tag-407","tag-180","tag-718"],"_links":{"self":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts\/2137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/comments?post=2137"}],"version-history":[{"count":0,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/posts\/2137\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/media?parent=2137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/categories?post=2137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.baishitou.cn\/wp-json\/wp\/v2\/tags?post=2137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}