Skip to content

Instantly share code, notes, and snippets.

@ipokkel

ipokkel/change-wordpress-user-meta-meta-key-name-example.sql

Created February 23, 2023 12:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ipokkel/c19f4d14178c99dc92b9f7cbc95bef96 to your computer and use it in GitHub Desktop.
Save ipokkel/c19f4d14178c99dc92b9f7cbc95bef96 to your computer and use it in GitHub Desktop.
Download ZIP
Example SQL of how to change a user meta meta key in the wp_usermeta table (note: your table prefix may differ from the default `wp_`). Always create a full database backup that you can restore to before making any changes to your database.
Raw
change-wordpress-user-meta-meta-key-name-example.sql
UPDATE wp_usermeta SET meta_key = 'first_name' WHERE meta_key = 'first-name'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment