What is the database table for pages?

admin管理员组

文章数量:1331091

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?

• database

Share Improve this question edited May 9, 2017 at 23:04 asked May 9, 2017 at 22:38 user87795user87795

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 13

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';

I entered to wp_posts and it seems all pages are inside there.

本文标签： What is the database table for pages