Using SELECT ... INTO OUTFILE

[Anon]

Quick question on sending search results to a text file:

I can get the following to work just fine:

SELECT * INTO OUTFILE '/home/me/out.txt' FROM MY_TABLE;

But I want to output something like *** between each record that is output:
how can I specify this in my query?

I can output the *** between each FIELD, but I only want to output it between each whole RECORD

Thanks for any help,
B

[Anon]

Ok.. done it:

SELECT INTO OUTFILE '/home/me/out.txt' LINES TERMINATED BY '**' FROM MY_TABLE;