help with update query

[john_6767]

i have a database that has " in some of the names of the fields and i am trying to write some sql to update these fields by replacing " with the word 'inch'. How would i go about doing this? php is having trouble with the "...

[AndyB]

In the names of the fields, or the data in the fields?

Trivial example below works:
[code]<?php
$old = 'This is a six" nail';
$new = str_replace('"',' inch',$old);
echo $new;
?>[/code]

[fenway]

MySQL has a replace function as well.