DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Replace Weird Characters In MySQL
Replace weird characters in MySQL database (usually caused by copy/paste from a Microsoft product)
update <table_name> set <table_field> = replace(replace(replace(replace(replace(replace(replace(replace(<table_field>,'’', '\''), '…', '...'),'–', '-'),'“', '"'),'â€Â', '"'),'‘', '\''),'•', '-'),'‡', 'c');
