I am using a standard GIS example from:
http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html
Newbie Question: How do I get back to lat, lon text?
CREATE TABLE address (
address CHAR(80) NOT NULL,
address_loc POINT NOT NULL,
PRIMARY KEY(address),
SPATIAL KEY(address_loc)
);
CREATE TABLE cab (
cab_id INT AUTO_INCREMENT NOT NULL,
cab_driver CHAR(80) NOT NULL,
cab_loc POINT NOT NULL,
PRIMARY KEY(cab_id),
SPATIAL KEY(cab_loc)
);
INSERT INTO address VALUES('Foobar street 12', GeomFromText('POINT(2671 2500)'));
SELECT address_loc FROM `address` where address="Foobar street 59"
returns
address_loc
Edit Delete ����~
/�\��-�^*B@
where I really need is the 2671 2500 text numbers.
Any help appreciated.
jim pruett