Tuesday, April 16, 2013

Chaning MySQL Text Fields for SEO Optimization



In this example I change turkish character set of name field from turkish to english words


select replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(name,'ü','u'),'ö','o'),'ı','i'),'ç','c'),'ş','s'),'ğ','g'),' ','-'),'.',''),'(','_'),')',''),',','') from geo_unit

LinkWithin

Related Posts Plugin for WordPress, Blogger...