Hello again,

using "SELECT...INTO OUTFILE" you can specify CSV/tab-delimited etc.
You can also specify fields enclosed by quotes for instance.

Is there a way to have only specific fields be enclosed by quotes while others not?

for instance, if my table constains the values:
1 | 2 | 3
can i output to a text file and have it look like:
1,"2",3

where only one field is enclosed by quotes?
thanks,