Removing an Appended " In front of Every Column

Answer 1

in sql server you coud do:

update mytable set state= substring(state,2,29)

change the "29" to whatever the actual length is.

I am sure mysql must have equivalent syntax.

Repeat for each field, it looks like there is only a handful of them.

Answer 2

As an alternative you could filter the original csv document - isn't that easier?

Answer 3

i'm not a MySql expert but this should work: (based on my similar experience in Sql Server)

UPDATE table_name SET col_name = REPLACE(col_name, '"', '')

For more info on the REPLACE and other string parsing functions, see here: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace