[MySQL database]

it is already running live on my host\'s server. I didn\'t notice this problem until now.

[MySQL database]

I converted a database created in Access to MySQL but I am having a problem. All of the data inside a field in a table is missing the ending quote and I am getting this message when trying to update the information....

 

ERROR: Unclosed quote @ 72

STR: \'

SQL:`arcmessages` WHERE `iMessageID` = \'7\' AND `txMessage` = \'darn...I wanted to be first...

Error

 

SQL-query :

 

 

`arcmessages` WHERE `iMessageID` = \'7\' AND `txMessage` = \'darn...I wanted to be first...

 

MySQL said:

 

 

You have an error in your SQL syntax near \'\'darn...I wanted to be first... \' at line 1

 

 

 

Is there anyway to go through and add the ending quote to all the rows in the field?