Find & Replace WordPress Domain

Find & Replace WordPress Domain

-- 1. Update siteurl and home
UPDATE wp_options 
SET option_value = REPLACE(option_value, 'http://site.local', 'https://site.com') 
WHERE option_name IN ('siteurl', 'home');

-- 2. Update post content (links, images, etc.)
UPDATE wp_posts 
SET post_content = REPLACE(post_content, 'http://site.local', 'https://site.com');

-- 3. Update GUIDs (optional - normally shouldn't be changed unless migrating)
UPDATE wp_posts 
SET guid = REPLACE(guid, 'http://site.local', 'https://site.com');

-- 4. Update postmeta
UPDATE wp_postmeta 
SET meta_value = REPLACE(meta_value, 'http://site.local', 'https://site.com');

-- 5. Update other custom tables or plugin tables if needed (search first)