How Do I Trim Leading and Trailing Quote from MySQL Row?

Try:

UPDATE `example_table` 
   SET `title` = TRIM(BOTH '"' FROM `title`)

This query will updated your example_table to remove leading and trailing double quotes from the value of the title column.

If you don’t want to update the table, but want to fetch the rows with double quotes removed, then use @Sam Dufel’s answer.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)