Advanced Search

Return to Snippet

Revision: 48718
at July 8, 2011 02:29 by beneberle
Updated Code 
UPDATE `table` SET `field` = REPLACE(`field`, '—', '-');
UPDATE `table` SET `field` = REPLACE(`field`, '“', '"');
UPDATE `table` SET `field` = REPLACE(`field`, '”', '"');
UPDATE `table` SET `field` = REPLACE(`field`, '”', '"');
UPDATE `table` SET `field` = REPLACE(`field`, '“', '"');
UPDATE `table` SET `field` = REPLACE(`field`, '–', '-');
UPDATE `table` SET `field` = REPLACE(`field`, '—', '-');
UPDATE `table` SET `field` = REPLACE(`field`, 'â€\”', '-');
UPDATE `table` SET `field` = REPLACE(`field`, '’', '\'');
UPDATE `table` SET `field` = REPLACE(`field`, '‘', '\'');
UPDATE `table` SET `field` = REPLACE(`field`, '’', '\'');

Revision: 48717
at July 8, 2011 02:27 by beneberle
Initial Code 
update `table` set `field` = replace(`field`, '—', '-');
update `table` set `field` = replace(`field`, '“', '"');
update `table` set `field` = replace(`field`, '”', '"');
update `table` set `field` = replace(`field`, '”', '"');
update `table` set `field` = replace(`field`, '“', '"');
update `table` set `field` = replace(`field`, '–', '-');
update `table` set `field` = replace(`field`, '—', '-');
update `table` set `field` = replace(`field`, 'â€\”', '-');
update `table` set `field` = replace(`field`, '’', '\'');
update `table` set `field` = replace(`field`, '‘', '\'');
update `table` set `field` = replace(`field`, '’', '\'');
Initial URL 









Initial Description














Initial Title





MySQL Special Character Replacements









Initial Tags














Initial Language





MySQL