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