CODE EXAMPLE FOR SQL

sql query wordpress export post

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