Converting Unescape Chars in MySQL for SEO
30
May0
May0
Sometimes, i need to convert datas for search engine optimization (SEO). I use MySQL replace command for this. Just login to phpmyadmin or any tool for run SQL command. Paste command set, change table and field name than run.
UPDATE table SET field = replace(field, 'À','A'); UPDATE table SET field = replace(field, 'Á','A'); UPDATE table SET field = replace(field, 'Â','A'); UPDATE table SET field = replace(field, 'Ã','A'); UPDATE table SET field = replace(field, 'Ä','A'); UPDATE table SET field = replace(field, 'Å','A'); UPDATE table SET field = replace(field, 'Æ','AE'); UPDATE table SET field = replace(field, 'Ç','C'); UPDATE table SET field = replace(field, 'È','E'); UPDATE table SET field = replace(field, 'É','E'); UPDATE table SET field = replace(field, 'Ê','E'); UPDATE table SET field = replace(field, 'Ë','E'); UPDATE table SET field = replace(field, 'Ì','I'); UPDATE table SET field = replace(field, 'Í','I'); UPDATE table SET field = replace(field, 'Î','I'); UPDATE table SET field = replace(field, 'Ï','I'); UPDATE table SET field = replace(field, 'Ò','O'); UPDATE table SET field = replace(field, 'Ó','O'); UPDATE table SET field = replace(field, 'Ô','O'); UPDATE table SET field = replace(field, 'Õ','O'); UPDATE table SET field = replace(field, 'Ö','O'); UPDATE table SET field = replace(field, '×','Z'); UPDATE table SET field = replace(field, 'Ø','O'); UPDATE table SET field = replace(field, 'Ù','U'); UPDATE table SET field = replace(field, 'Ú','U'); UPDATE table SET field = replace(field, 'Û','U'); UPDATE table SET field = replace(field, 'Ü','U'); UPDATE table SET field = replace(field, 'ß','ss'); UPDATE table SET field = replace(field, 'à','a'); UPDATE table SET field = replace(field, 'á','a'); UPDATE table SET field = replace(field, 'â','a'); UPDATE table SET field = replace(field, 'ã','a'); UPDATE table SET field = replace(field, 'ä','a'); UPDATE table SET field = replace(field, 'å','a'); UPDATE table SET field = replace(field, 'æ','ae'); UPDATE table SET field = replace(field, 'ç','c'); UPDATE table SET field = replace(field, 'è','e'); UPDATE table SET field = replace(field, 'é','e'); UPDATE table SET field = replace(field, 'ê','e'); UPDATE table SET field = replace(field, 'ë','e'); UPDATE table SET field = replace(field, 'ì','i'); UPDATE table SET field = replace(field, 'í','i'); UPDATE table SET field = replace(field, 'î','i'); UPDATE table SET field = replace(field, 'ï','i'); UPDATE table SET field = replace(field, 'ñ','n'); UPDATE table SET field = replace(field, 'ü','u'); UPDATE table SET field = replace(field, 'ò','o'); UPDATE table SET field = replace(field, 'ó','o'); UPDATE table SET field = replace(field, 'ô','o'); UPDATE table SET field = replace(field, 'õ','o'); UPDATE table SET field = replace(field, 'ö','o'); UPDATE table SET field = replace(field, 'ø','o'); UPDATE table SET field = replace(field, 'ù','u'); UPDATE table SET field = replace(field, 'ú','u'); UPDATE table SET field = replace(field, 'û','u'); UPDATE table SET field = replace(field, 'ÿ','y');
View this post on FriendFeed
No Comments
No comments yet.
Sorry, the comment form is closed at this time.

