Parsing out special characters in outfile

clem_c_rock · Joined: 18 Aug 2004 Posts: 19

Hello,
I am looking for a way to parse out certain characters when I write a select statement to an outfile.

I know how to escape the characters w/ the escaped by clause, but I need to parse off some double quotes and some backslashes.

I'm currently trying this:

[code:1]
select id, name from artists where id in(14346, 25919, 76150) INTO OUTFILE '/tmp/test_5.csv' FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\n'
[/code:1]

Is there anyway to do this w/ native mysql functions?

Thanks,
Clem

clem_c_rock · Joined: 18 Aug 2004 Posts: 19

Found the solution I was looking for (nested REPLACE statements):

insert into artists(name) values(REPLACE(REPLACE(REPLACE(name,'!', ''),'"', ''),'\302\256', '') );