When I go through the database of a fresh Wordpress 4 install I find, for example:
wp_posts
wp_terms
wp_users
Yet I didn't find `wp_pages'. Where is it?
When I go through the database of a fresh Wordpress 4 install I find, for example:
wp_posts
wp_terms
wp_users
Yet I didn't find `wp_pages'. Where is it?
Share Improve this question edited May 9, 2017 at 23:04 asked May 9, 2017 at 22:38 user87795user877952 Answers
Reset to default 13the wp_posts include all post types (post, page, custom post..), and to differentiate between them there is a field called post_type used to specify the name of the current entry whether it's a page, post or a custom post.
Query below will get list of pages
SELECT * FROM wp_posts where post_type = 'page';
I entered to wp_posts and it seems all pages are inside there.