Re: How to un-convert GeomFromText()

[jimbo pruett]

ok, it looks like I just needed the astext() function.
Q: How do I get lat, lon? or do I just strip it off somehow?
Q: Is there a function to strip the word POINT?
thanks for any replys
jim


this

SELECT astext( address_loc ) FROM `address`;

returns

astext( address_loc )
POINT(2671 2500)
POINT(2971 2520)
POINT(3171 2510)
POINT(-114.877871869233 36.3310176346906)

^^^^ how do I get rid of the word POINT above? ^^^^^