MySQL选择多边形包含点的位置始终为false [英] Mysql select where polygon contains point always false

问题描述

我尝试了各种功能，例如MBRWithin，MBRContains，Intersects，Contains(在此处的大量帖子中都找到了这些功能)，但还没有碰到运气.这是简化的查询:

I have tried various functions like MBRWithin, MBRContains, Intersects, Contains (all of them found in a plenty of posts around here) but no luck yet. This is the simplified query:

SELECT * FROM  users
WHERE Intersects( GeomFromText( 'POINT(50 50)' ), GeomFromText( 'POLYGON(0 0, 100 0, 100 100, 0 100, 0 0)' ) );

我希望它可以将该条件评估为真(如1 = 1)并返回所有用户，但是这没有发生.请告诉我，我在做什么错了?

I expected it to evaluate that condition as true (like 1=1) and return all users, however this did not happen. Please tell me, what am I doing wrong?

我正在运行MySql 5.5

I am running MySql 5.5

推荐答案

这对我有用:

SELECT
    *
FROM 
    users
WHERE
    MBRContains(
        GeomFromText('Polygon((0 0,0 100,100 100,100 0,0 0))'),
        GeomFromText('Point(50 50)')) = 1;

这篇关于MySQL选择多边形包含点的位置始终为false的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！