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 mysql query to get all posts with a missing custom field
  2. WordPress mysql query to get all posts with a specific custom field
  3. Mysql query to find all yoast meta description
  4. WordPress – query to dump all posts with featured image
  5. How to delete orphan wordpress wp_postmeta rows
  6. How to hide a post from home and RSS feed in wordpress
  7. WordPress – an approach to bulk add tags to posts
  8. Query to find recently modified posts in WordPress
Share this article: share on Google+ share on facebook share on linkedin tweet this submit to reddit

Comments

Click here to write/view comments