MySQL query to replace a character

[writethegeek]

I have a table called "Recipes" with a column called "description". Within the description column there are quotes and apostrophes which I would like to replace with blank spaces.

Do you know of a query that will replace only these characters within the description column. I have tried several queries, but no luck as of yet.

Chris David

[Brendan_Nolan]

I don't know if you can do it using only SQL... would a PHP script suit you?

[writethegeek]

I actually worked it out on my own earlier. I used:
UPDATE TableName SET ColumnName=REPLACE(ColumnName,'BADCHAR','NEWCHAR');

It replaced only the individual characters and not the entire field.

Thanks for the input though. Hopefully these posts will help others.