I have a MySQL table that I have imported from a CSV file. In this process, a bunch of the entries have quote marks leading and trailing the entry of several data rows. For example the the table 'example_table' I have a row called 'title.' Some of these titles are written as:
"title1"
"title2"
"title3"
and some are written without the quote marks:
title4
title5
title6
I have tried a variety of SQL calls to trim the row but I keep getting errors. Here is my sql call:
SELECT * FROM `example_table` TRIM(LEADING '"' FROM "title")
This is the error from MySQL when I run the call:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
How do I go about getting rid of all the trailing and leading quotation marks from the row?