WordPress mysql query to get all custom keys and values for a post

By on

Handy mysql query to get all custom keys and values for a post in wordpress.

SELECT wp_postmeta.*
FROM wp_postmeta 
JOIN wp_posts ON wp_posts.ID = wp_postmeta.post_id
WHERE wp_posts.ID = 5671

Here is sample outcome from the above query:
wordpress-post-all-custom-keys-query-outcome

Suggested posts:

  1. WordPress – query to dump all posts with featured image
  2. How to delete orphan wordpress wp_postmeta rows
  3. WordPress – an approach to bulk add tags to posts
  4. WordPress – query to find all posts for a category
  5. WordPress mysql query to get all posts with a missing custom field
  6. WordPress mysql query to get all posts with a specific custom field
  7. Find all user created wordpress custom field keys
  8. How to setup wordpress custom query params with pretty url format
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged , , ,