Skip to content

Instantly share code, notes, and snippets.

@lkoudal

lkoudal/count_different_meta_key

Last active July 14, 2020 21:11
Show Gist options
  • Save lkoudal/5f63f484c3dbf168bef7ac178262d836 to your computer and use it in GitHub Desktop.
Save lkoudal/5f63f484c3dbf168bef7ac178262d836 to your computer and use it in GitHub Desktop.
Download ZIP
Count how many different kind of meta_key's there are - and how many there are of each.
Raw
count_different_meta_key
SELECT meta_key, COUNT( * ) c FROM `wp_postmeta` GROUP BY meta_key ORDER BY `c` ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment