trim leading and trailing double quotes using mysql query

you can trim trim leading and trailing double quotes using mysql update query,

UPDATE table SET field_name = TRIM(BOTH '"' FROM table)

the above query will trim/remove double quotes from leading and trailing content of the given field...