CODE EXAMPLE FOR SQL

mysql remove bad character from all fields

#replace a bad character with somethine else you want
UPDATE myTable SET myColumn = REPLACE(myColumn, "'", "'")