Skip to content

Instantly share code, notes, and snippets.

@lfbittencourt

lfbittencourt/WpHostChange.sql

Created September 5, 2013 18:38
Show Gist options
  • Save lfbittencourt/6454276 to your computer and use it in GitHub Desktop.
Save lfbittencourt/6454276 to your computer and use it in GitHub Desktop.
Download ZIP
Use this query to change a WordPress host hardcoded in options table.
Raw
WpHostChange.sql
UPDATE
wp_options
SET
option_value = REPLACE(option_value, 'oldhost/somedirectory', 'newhost')
WHERE
option_value LIKE '%oldhost/somedirectory%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment