Query to import data into a text file

[databaseforum]

Hi,

I am importing the data of all columns to the corresponding text file seperated by | each field.

For example:I have one table 'hello' with 4 column values as '20','vsffg','abc',39'.
Now i am importing tht data into my hello.txt file as
20|vsffg|abc|39 .
I am doing above operation using
Select * into outfile operation
its importing properly..
each row in my hello.txt file contains one complete record information
Now problem is for some of the columns in table like 'comments' whose size is 255.contains new line character internally.
So my hello.txt file taking tht as a seperate line.
For example i have one table 'hello2' with 4 column values as '20','vghjk klmns','45'90'.

Now my hello2.txt file contains

20|vghjk
45|90

i want to display each record in one row only .please provide me simple query for it.How to modify my existing query
Fields terminated by '|' lines terminated by \r\n'.