Export WordPress Posts and Meta Information in CSV format (2 posts)

  1. sixfootjames
    Posted 2 years ago #


    I need to export all WordPress Posts and related Meta information using an SQL query. I've managed to export just the Posts but realised that the Meta information is in another table.

    Could someone please tell me how I would go about doing this please?


  2. sixfootjames
    Posted 2 years ago #

    Here's some additional information to help with my needs:

    The final outcome of the CSV file should look something like this. On one row, these are the columns that I will end up with. (I will delete the additional columns in CSV, I'm just giving a shortened version here)

    [FROM POSTS TABLE] post_content | post_title | post_excerpt | Author (meta_key) | [FROM META TABLE] AuthorName (meta_value) | Publisher (meta_key) | PublisherName (meta_value) | BookCondition (meta_key) | BookCondition (meta_value)

    So one post per row with the meta information in the same row.

    I have already tried a number of plugins, none of which have worked for this specific scenario. I really do need to work on the query itself. Thanks

Topic Closed

This topic has been closed to new replies.

About this Topic