How to select coordinate from mysql database -
i can select column of type 'point' using
select astext(column) mytable;
it returns:
'point(1.2, 3.4)'
but can select as
'1.2, 3.4'
? can done in backend (of course) can mysql convert me?
there special functions st_x, st_y, e.g.:
select concat(st_x(point_column), ', ', st_y(point_column)) points_table
Comments
Post a Comment