Export Data from Mysql to CSV files

WordPress Posts export example:

(SELECT 'Post Date','Post Title','Post Content') 
UNION 
(select post_date, post_title, post_content from wp_posts 
INTO OUTFILE '/tmp/wordpress_posts.csv' 
FIELDS ENCLOSED BY '"' 
TERMINATED BY ',' 
ESCAPED BY '"' 
LINES TERMINATED BY '\n');