Loading

update existing data format

vishal sahani

15y1.8k

hi
i have a database with a very large data in it.the data is stored in double quotes eg "india" in the columns.i want to store the data without the double quotes eg india .is there a way to do this or update the existing table.
thanx in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

15y ago
You can use replace function for this.

You can try the following query.

update set = REPLACE(,'"','') where