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

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -