WordPress 批量修改图片及网站地址sql语句.note

创建时间：1361356637 修改时间： 1559799545

6955-1559799545745# 修改链接地址08Courier New081608#fafafa1.0996125#fafafa6765-1559799545746UPDATE wp_options06true017Courier New0171606#006699017#ffffff1.0996125#ffffff3290-1559799545747SET option_value = replace( option_value,'www.likebeta.com','localhost/workspace/sys/wordpress')03true096Courier New0961603#0066991926#ff14934159#0000ff6095#0000ff096#fafafa1.0996125#fafafa6717-1559799545750WHERE option_name = 'home' OR option_name = 'siteurl';05true054Courier New0541605#0066992026#0000ff2729#8080804453#0000ff054#ffffff1.0996125#ffffff2044-1559799545752   03Courier New031603#fafafa1.0996125#fafafa7914-1559799545755UPDATE wp_posts SET post_content = replace( post_content,'www.likebeta.com','localhost/workspace/sys/wordpress');06true1619true0113Courier New01131606#0066991619#0066993542#ff14935775#0000ff76111#0000ff0113#ffffff1.0996125#ffffff2466-1559799545758   03Courier New031603#fafafa1.0996125#fafafa6410-1559799545759UPDATE wp_posts SET guid = replace( guid,'www.likebeta.com','localhost/workspace/sys/wordpress');06true1619true097Courier New0971606#0066991619#0066992734#ff14934159#0000ff6095#0000ff097#ffffff1.0996125#ffffff6010-1559799545761   03Courier New031603#fafafa1.0996125#fafafa1722-1559799545761# 修改图片地址08Courier New081608#ffffff1.0996125#ffffff3633-1559799545761UPDATE wp_posts SET post_content = 06true1619true035Courier New0351606#0066991619#006699035#fafafa1.0996125#fafafa2858-1559799545763REPLACE(post_content, 'src="http://img.likebeta.com/www', 'src="http://localhost/workspace/sys/wordpress/wp-content/uploads');2855true64123true0126Courier New01261607#ff14932256#0000ff58124#0000ff0126#ffffff2855http://img.likebeta.com/www64123http://localhost/workspace/sys/wordpress/wp-content/uploads1.0996125#ffffff1765-1559799545766    04Courier New041604#fafafa1.0996125#fafafa7381-1559799545767UPDATE wp_posts SET06true1619true019Courier New0191606#0066991619#006699019#ffffff1.0996125#ffffff8540-1559799545768guid = REPLACE (guid, 'http://img.likebeta.com/www', 'http://localhost/workspace/sys/wordpress/wp-content/uploads') 2350true54113true0116Courier New011616714#ff14932251#0000ff53114#0000ff0116#fafafa2350http://img.likebeta.com/www54113http://localhost/workspace/sys/wordpress/wp-content/uploads1.0996125#fafafa2738-1559799545772WHERE post_type = 'attachment';05true031Courier New0311605#0066991830#0000ff031#ffffff1.0996125#ffffff