What is the database table for pages?

by

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?

2 Answers
2

the 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";

Leave a Comment