Research Links
- YTvid; How to export a list of all your WordPress posts (using a simple SQL query in phpMyAdmin) – showed the Query which for some reason does not produce duplicates from the duplicates that result from revisions
- Exporting a list of all your WordPress posts (with publication dates) using SQL
This is a modified version of the query shown in the second link. The result of this search yields only title and publication dates for purposes of organizing the website articles with Table of Contents
SELECT
post_title,
post_date
FROM
wp_posts
WHERE
post_type = 'post'
ORDER BY
post_date
0 Comments