Nope :-(. You need to write a php script (or, whatever language you want) to retrieve all the records, fix each record, and then shove it back to the dictionary.

Actually, while PHP is useful, it is not necessary. I think you can telnet into mysql or something like that.
If you were to use a php script, here's some inefficient code:
Assuming your database was named "mydb" and your table was named "mytable" and included fields "id" and "text":
[PHP]
<?
$db = mysql_connect("localhost", "username", "password") or die(mysql_error()); //connect to mysql

mysql_select_db("mydb",$db); //select the database

$table = mysql_query("SELECT * FROM mytable", $db) or die(mysql_error()); //grab the table data

while($row = mysql_fetch_assoc($table)){ //do this for every row in the table

$newtext = str_replace(""", '"', $row['text']); //replace " with " in the text field and store that as the variable newtext

if ($newtext !== $row['text']){ //if newtext is different from the database value, then we need to update

$tmp = mysql_query("UPDATE mytable SET text = '$newtext' WHERE id = $row['id']", $db) or die(mysql_error()); //update the database

} //end if statement

} //end while loop

?>
[/PHP]
I only checked it for syntax but just IM me if you have any trouble.

on the str_replace line, thats:

$newtext = str_replace("AMPERSAND Q U O T SEMICOLON", 'REGULAR DOUBLE QUOTE', $row['text']);

Dani, the script appears fine. How you implemented it isn't. There is only so much I can do with the given information. Please include a copy of the error message, along with a copy of your edited code (except the password of course), and a simple table layout explanation. Also include your PHP version.
Sorry this has been giving you trouble and I'll be glad to help, just need some more info.

Heh... This is kinda OT, but this thread is a great example on how good TTF really is.

When someone is having a problem (even the administrator!) there is always someone to help with it.

Just had to compliment all the members of TTF for this amazing dream to become a reality.

$your_data=str_replace(array('"'), """, $your_data);:rolleyes: