update existing data format

Question

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

Muralidharan Deenathayalan · Answer

You can use replace function for this. You can try the following query. update set = REPLACE( '''') where