Create KML From Mysql SHAPE

update  province_geo set kml=astext(SHAPE)

SELECT REPLACE( FieldName ,'คำที่ค้นหา','คำที่เอามาแทน' ) AS NewData FROM TableName

update  amphoe_geo set kml=astext(SHAPE)

update  amphoe_geo set kml=replace(kml,')','');

update  amphoe_geo set kml=replace(kml,'(','');

update  amphoe_geo set kml=replace(kml,'MULTIPOLYGON','');

update  amphoe_geo set kml=replace(kml,'POLYGON','');

update  amphoe_geo set kml=replace(kml,',','|');

update  amphoe_geo set kml=replace(kml,' ',',');

update  amphoe_geo set kml=replace(kml,'|',' ');