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.