MySQLPostgreSQL

SQL Query: Remove Leading and Trailing Double Quotes

Posted Ricardo Malla

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'

Attachments:

Leave a Reply

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