How can we stock the query result into a text file

[Lin Chun]

Hi

In mysql , how can we stock the query result into a text file

the table is too large , i don't want to dump it , but select a part of it,
i wrote a script perl to do this, but each time i have to change the
parameters in the script to get another table, when i google it, i find the
function in Oracle

"
spool 'filenameandpath.txt'

select ...
from ..
/

spool off
"
does Mysql has such function?




-- 
-------------------------
Lin Chun