MySQL Special Character Replacements


/ Published in: MySQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.