Answers for "export post wordpress"

add post meta wordpress

<?php

$post_id = 1;
$meta_key = '_test';
$meta_value = 'this is a test';
$unique = true;

add_post_meta( $post_id, $meta_key, $meta_value, $unique );

sql query wordpress export post

SELECT * 
FROM  `wp_posts` 
WHERE  `post_type` =  "post type name here"