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:



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

Thanks,
Clem

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


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