Get all post from table and put it in excel sheet

Question

Here’s the SQL I used to create this view in phpMyAdmin. Since you cannot get the permalink URL out of the database we have to pull the GUID. This link does in fact get you to your post, since it uses the unique ID of the post.

SELECT `post_name`, `guid`
FROM `YOUR_TABLE` 
WHERE `post_date` >= DATE('2014-01-01')
ORDER BY `post_date` DESC

For all of the data in your posts table use:

SELECT * 
FROM `YOUR_TABLE` 
WHERE `post_date` >= DATE('2014-01-01')
ORDER BY `post_date` DESC