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?