Posted By

beneberle on 07/08/11


Tagged


Versions (?)

MySQL Special Character Replacements


 / Published in: MySQL
 

  1. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '—', '-');
  2. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '“', '"');
  3. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '”', '"');
  4. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '”', '"');
  5. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '“', '"');
  6. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '–', '-');
  7. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '—', '-');
  8. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, 'â€\”', '-');
  9. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '’', '\'');
  10. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '‘', '\'');
  11. UPDATE `table` SET `FIELD` = REPLACE(`FIELD`, '’', '\'');

Report this snippet  

You need to login to post a comment.