sql query: remove leading and trailing double quotes By Ricardo MallaSeptember 16, 2016mysql, postgresql UPDATE m_product SET name = TRIM(BOTH '"' FROM name) WHERE m_product_id = '1128493' UPDATE m_product set name = replace(name, '""', '"') WHERE m_product_id = '1128493'