Skip to content

Instantly share code, notes, and snippets.

@digisavvy

digisavvy/Getting Postmeta For a Post.sql

Created May 8, 2023 16:58
Show Gist options
  • Save digisavvy/4cbd943d8106e5bfdd6e9ad5410a43da to your computer and use it in GitHub Desktop.
Save digisavvy/4cbd943d8106e5bfdd6e9ad5410a43da to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Getting Postmeta For a Post.sql
SELECT *
FROM wp_postmeta
WHERE post_id = {your_post_id}
AND post_id IN (SELECT ID FROM wp_posts WHERE post_type = '{your_posttype}');
With the above query, replace {your_post_id} and {your_posttype} with the appropriate post ID and posttype.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment