mysql point 距离,查找MYSQL中两点之间的距离。 （使用点数据类型）

Suppose I have a 2 column table like this:

| user_id | int(11) | NO | UNI | NULL | |

| utm | point | NO | MUL | NULL | |

As you can see, it's very simple. utm is a Point data-type. I insert it like this:

INSERT INTO mytable(user_id, utm) VALUES(1, PointFromWKB(point(50, 50)));

Then, I create a Spatial index.

ALTER TABLE mytable ...add spatial index on(utm) or something. (forgot)

Alright, everything is good. Now , I want to select * where distance < 99999.

But it doesn't work!

//This is supposed to select all where the distance is less than 99999999.

set @mypoint = PointFromWKB(point(20,20))

select * from mytable where GLength(LineString(utm, @mypoint)) < 9999999;

Empty set (0.00 sec)

select * from mytable where GLength(LineStringFromWKB(LineString(utm, @mypoint))) < 9999;

Empty set (0.00 sec)

By the way, I have tried to INSERT INTO without the PointFromWKB...and it didn't work...that's why someone suggested that PointFromWKB to me.

解决方案

Solved. This is what I did:

where GLength(LineStringFromWKB(LineString(asbinary(utm), asbinary(@mypoint)))) < 9999999999999;