Need help with MySQL query for Wordpress -

My problem is not with the WPDB class of Wordpress, but with MySQL syntax. I'm trying to do the following sequence:

• Get an array of all post IDs
• Filter posts from a specific category
• Filter Show only published content, duplicate, modify, draft etc.

Help? Thank you.

Use that for the query by passing the query id or category name. All this has been explained on the link.

Edit after your comments:

You can use get_posts, however, both AFAIK return returns.

  $ post = meet ('category = 1'); Forex Currency ($ post $ post) {echo $ post- & gt; Id; // or what you want to do with it ...}