http://www.mysql.com/doc/en/SELECT.html

In particular, look at the section on 'export_options'. The example which is pertinant is:

SELECT a,b,a+b INTO OUTFILE "/tmp/result.text"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM test_table;
[download]

hth
-- dug