mysql - 在 MySQL 函数调用中使用 Select 语句

Question

在下面的 MySQL 存储函数调用中，我不想手动输入经纬度坐标，而是想从另一个表中选择一个多边形进行测试。我在正确使用语法时遇到问题。

SELECT IS_POINT_IN_POLYGON(
POINTFROMTEXT( CONCAT( 'POINT(', latitude, ' ', longitude, ')' ) ) , POLYFROMTEXT( 'POLYGON((43.40930419213147, -72.5537109375
43.40884544242924, -72.53695249557495
43.38754804789373, -72.5437331199646
43.378580946950244, -72.58398771286011
43.40930419213147, -72.5537109375 ))' )
)AS result, latitude, longitude
FROM sport
WHERE sport_type = 'lacrosse' AND IS_POINT_IN_POLYGON(
POINTFROMTEXT( CONCAT( 'POINT(', latitude, ' ', longitude, ')' ) ) , POLYFROMTEXT( 'POLYGON((43.40930419213147, -72.5537109375
43.40884544242924, -72.53695249557495
43.38754804789373, -72.5437331199646
43.378580946950244, -72.58398771286011
43.40930419213147, -72.5537109375))' )
) = 1;

所以，我想删除 43.40930419213147, -72.5537109375 43.40884544242924, -72.53695249557495 43.38754804789373, -72.5437331199646 43.378580946950244, -72.58398771286011 43.40930419213147, -72.5537109375

相反，我想使用这个选择语句:

SELECT neighborhood_polygon FROM `neighborhood_shapes` WHERE neighborhood="XYZ neighborhood"

我将多边形存储在 neighborhood_shapes 中。其结构如下:

• neighborhood_index smallint(3)
• 社区 varchar(50)
• neighborhood_polygon(几何)

附加信息:

IS_POINT_IN_POLYGON 的调用方式如下:IS_POINT_IN_POLYGON(p POINT, poly POLYGON)

有什么建议吗？

Answer 1

尝试这样做。

... POLYFROMTEXT(
    (SELECT neighborhood_polygon 
      FROM neighborhood_shapes 
      Where neighborhood = "XYZ neighborhood") as coords)