mysql - Removing an Appended " In front of Every Column -

I found a CSV database of city / zip / gps, and when I imported it, it was "in front of the columns.
I do not want to enter 33,000 entries and want to do it manually, is there a query that I will remove quotes?

I'm not a MySQL expert but it should work: (my server in SQL Server Value based on experience)

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

and for more information on other string parsing functions, see here :