How to export post from particular category id from phpmyadmin?

Use the query below;

SELECT * FROM wp_posts p
JOIN wp_term_relationships tr
   ON (p.ID = tr.object_id)
JOIN wp_term_taxonomy tt
   ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy='category')
JOIN wp_terms t
   ON (t.term_id = tt.term_id AND t.term_id = 38)
WHERE 1=1
AND p.post_type = 'post'
AND p.post_status = 'publish'