sql query wordpress export post code example

Example: sql query wordpress export post

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