spatial indexes in mysql

SELECT name, AsText(loc) FROM map_test WHERE
Contains(GeomFromText(‘POLYGON((0 0, 0 1, 1 1, 2 0, 0 0))’), loc) = 1;
(via jeremy zawodny)
KAYWA are you listening? i’d imagine this to be quite useful with some location metadata..