Title: export list from posts: problem “guid” Last modified: August 19, 2016 --- # export list from posts: problem “guid” * [sdamy](https://wordpress.org/support/users/sdamy/) * (@sdamy) * [17 years, 1 month ago](https://wordpress.org/support/topic/export-list-from-posts-problem-guid/) * My problem: * I must export a list from table “posts” with only two column, post_author and guid (the url of article) but in the export list I find many record with this text in the guid: “[http://www.site.com/?p=3629″](http://www.site.com/?p=3629″);. All the article must have guid =”[http://www.site.com/name_article.html”](http://www.site.com/name_article.html”);. * For example the article with id=3629 is publis and the data are: * (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`,` post_category`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`,` post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`,` post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`,` comment_count`) VALUES (3629, 1, ‘2008-12-06 14:59:06’, ‘2008-12-06 15:59:06’,‘ xxxxxxxxxxx’ />
’, ‘xxxxxxxxxxx’, 0, ”, ‘publish’, ‘open’, ‘open’, ”,‘ xxxxxxxxx’, ”, ”, ‘2008-12-06 15:33:57’, ‘2008-12-06 16:33:57’, ”, 0, ‘[http://www.site.com/?p=3629’](http://www.site.com/?p=3629’);, 0, ‘post’, ”, 0); * I’ve setting my wp with permalink: /%postname%-%post_id%.html * What’s the problem? * thanks and sorry for my english The topic ‘export list from posts: problem “guid”’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 0 replies * 1 participant * Last reply from: [sdamy](https://wordpress.org/support/users/sdamy/) * Last activity: [17 years, 1 month ago](https://wordpress.org/support/topic/export-list-from-posts-problem-guid/) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics