How can I remove quotation marks?

I have entries in a mysql database with quotation marks surrounding some of them.

For example:
Field1: Dog
Field2: "Poodle"
Field3: Poodles are nice and they are small.

Is there a way to automatically remove the quotation marks surrounding the entries? It would take way too long to do manually.

Thanks so much!

Sure, just run an update query to replace the value with the same value but without thwe quotes, wherever a value starts and ends with a quote.

Read the string-functions section of the mysql manual.

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Thanks, but I'm not sure how to do that...

My example:
Field1: Dog
Field2: "Poodle"
Field3: Poodles are nice and they are small.

Looking at the manual, I tried this:

SELECT * FROM Animals WHERE Field2 LIKE '"%"' TRIM('"');

and

SELECT Field2 FROM Animals TRIM(");

and some other variations and I can't get it.

If you know how I would much appreciate it.

Thanks in advance, you are awesome!

Flattery will get you everywhere...

Note: MAKE A BACKUP OF YOUR DATA BEFORE RUNNING THIS!
This is irreversable, it can only be undone by a restore.

UPDATE yourtable SET yourfield=TRIM(BOTH '"' from yourfield);

You may have to escape the quote to avoid a parse error in PHP.