Unable to use Spatial.. More extensions?

[John Matter]

I wanted to play with spatial extensions with MySQL. I did a install of mysql and followed the examples at http://dev.mysql.com/tech-resources/articles/4.1/gis-with-mysql.html

I was able to create the table using:

CREATE TABLE address (
address CHAR(80) NOT NULL,
address_loc POINT NOT NULL,
PRIMARY KEY(address),
SPATIAL KEY(address_loc)
);

and then do the following insert to it:

INSERT INTO address VALUES('Foobar street 12', GeomFromText('POINT(2671 2500)'));

But when I select * from the address, the address_loc is blank.. Any queries returns a empty set. Is there anything special which needs to be done to enable it? Please advice.