Export WordPress Posts and Meta Information in CSV format

  • sixfootjames

    (@sixfootjames)


    11 years, 6 months ago

    Hi,

    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?

    Thanks!

Viewing 1 replies (of 1 total)
  • Thread Starter sixfootjames

    (@sixfootjames)

    11 years, 6 months 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

Viewing 1 replies (of 1 total)
  • The topic ‘Export WordPress Posts and Meta Information in CSV format’ is closed to new replies.