Please tell me how to export a MySQL table to a pipe delimited file ...

Got it....

SELECT * FROM TABLE ORDER BY ID INTO OUTFILE 'out.file' FIELDS TERMINATED BY '|';