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. PHP check if key exists in array
  2. HTML li tag
  3. Chrome – view javascript errors
  4. How to search files by name in Mac Finder
  5. jQuery – difference between html() and text()
  6. WordPress – query to find all posts for a category
  7. How to create Linux instance on Amazon AWS/EC2 Classic
  8. How to find mysql query rate on Linux
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in | Tagged , , ,