Find/replace within option values with SQL in phpmyadmin
-
What’s the correct query to find and replace options values? I need to find/replace a bunch of URLs in option_values of an option_name called widget_text
I changed all URLs in options with this:
UPDATE bierken_options SET option_value = replace(option_value, 'http://www.olddomain.com', 'http://www.newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
but that didn’t get the widget text, and Search Regex doesn’t pick up the widget text, either.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
- The topic ‘Find/replace within option values with SQL in phpmyadmin’ is closed to new replies.