Skip to content

Instantly share code, notes, and snippets.

@travisfont
Created December 5, 2017 16:37
Show Gist options
  • Save travisfont/029b37713de3fca3aac52365450b8442 to your computer and use it in GitHub Desktop.
Save travisfont/029b37713de3fca3aac52365450b8442 to your computer and use it in GitHub Desktop.
MySQL: Get Custom Post Type & Custom ACF by Post Name
ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent guid menu_order post_type post_mime_type comment_count
------ ----------- ------------------- ------------------- ------------ ------------------ ------------ ----------- -------------- ----------- ------------- ----------------- ------- ------ ------------------- ------------------- --------------------- ----------- --------------------------------------------------- ---------- --------- -------------- ---------------
2348 4 2017-11-29 09:33:03 2017-11-29 09:33:03 Travis Test publish closed closed travis-test 2017-11-29 09:36:09 2017-11-29 09:36:09 0 http://example.com/?post_type=contacts&p=2348 0 contacts 0
2352 4 2017-11-29 09:34:57 2017-11-29 09:34:57 Travis Test Jr. publish closed closed travis-testjs 2017-11-29 09:35:28 2017-11-29 09:35:28 0 http://example.com/?post_type=contacts&p=2352 0 contacts 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment