Skip to content

Instantly share code, notes, and snippets.

@alaasalama

alaasalama/SQL change meta_key name

Last active March 15, 2016 19:35
Show Gist options
  • Save alaasalama/a121e77fe7ff428f1e80 to your computer and use it in GitHub Desktop.
Save alaasalama/a121e77fe7ff428f1e80 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL change meta_key name
UPDATE`wp_postmeta`SET`meta_key`= 'views_temp' WHERE`meta_key`= 'views'
UPDATE`wp_postmeta`SET`meta_key`= 'tie_views_temp' WHERE`meta_key`= 'tie_views'
UPDATE`wp_postmeta`SET`meta_key`= 'tie_views' WHERE`meta_key`= 'views_temp'
UPDATE`wp_postmeta`SET`meta_key`= 'views' WHERE`meta_key`= 'tie_views_temp'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment