sql query: remove leading and trailing double quotes

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'

Leave a Reply

Your email address will not be published. Required fields are marked *