• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

WP Bitz

A curated collection of code snippets for WordPress

  • Home
  • About
  • Blog
  • Code Snippets
You are here: Home / Code Snippets / MySQL UPDATE and REPLACE

MySQL UPDATE and REPLACE

October 6, 2020

This post brought to you by RocketGeek, ButlerBlog, and the following:

 

UPDATE wp_posts
SET
    post_content = REPLACE( post_content, 'http://mysite.com', 'https://mysite.com' ),
    guid = REPLACE( guid, 'http://mysite.com', 'https://mysite.com' )
WHERE 
    post_content LIKE '%http://mysite.com%'
    OR guid LIKE '%http://mysite.com%';

Chad Butler

Primary Sidebar

Join for free!

Get free code snippets, WordPress best practices, and practical Content Marketing advice from seasoned WordPress expert Chad Butler (butlerblog):

Recent Posts

  • Bitnami WordPress Autoptimize cannot write to the cache directory
  • Create and delete WordPress sites in XAMPP with a batch file
  • How to fix “Error: MySQL Shutdown Unexpectedly” in XAMPP control panel
  • Fix missing Customizer in WordPress 6
  • Use Proofy.io API to validate WordPress registrations

Copyright © 2023 · Maker Pro on Genesis Framework · WordPress · Log in