export posts from one category from databse (2 posts)

  1. kappaluppa
    Posted 10 years ago #

    I am trying pull posts from only one category out of the database. In the wp-posts table there is a field called post_category, but all the posts have a 0 in that field.

    Anyone know how I can search for all posts from category X.

    I know how to display only posts from a category in the blog, but I want to export them from the database so I can put them into another database.

    Thanks! K

  2. Chris_K
    Posted 10 years ago #

    you'll need to join posts with post2cat.

    If you're going to another blog (or web app) have you considered pulling a category based RSS feed from your blog and importing it to the other?

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.