Skip to content

Instantly share code, notes, and snippets.

@wpsmith

wpsmith/replaceMetaKey.sql

Created October 30, 2013 03:10
Star
Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
SQL: Replace User Meta Key
Raw
replaceMetaKey.sql
UPDATE wp_usermeta SET meta_key = REPLACE (meta_key, 'old_name', 'new_name');
UPDATE myprefix_usermeta SET meta_key = REPLACE (meta_key, 'old_name', 'new_name');
@wpsmith
Copy link
Author

wpsmith commented Feb 15, 2014

For more information, see the tutorial here: http://wpsmith.net/2014/snippets/popular-wordpress-sql-user-administration-scripts/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment