知识点记录:MySQL操作geometry数据类型--根据范围查询内部的点
ST_CONTAINS 函数
学习自:https://www.cnblogs.com/magicpose/p/12067494.html
st_contains(g1, g2)
返回1: g1完全包含g2;返回0: g1未包含g2,即true/false
数据结构问题:
学习自:https://zhuanlan.zhihu.com/p/268071994
8.0+的数据库需要在函数前加上“ST_”
SELECT
n.*
FROM
ngp n
WHERE
ST_CONTAINS (
ST_POLYGONFROMTEXT ( ‘POLYGON((120.51302927327897 30.648988074576557,120.52734695211282 30.64928814568983,120.52618953496153 30.63304143827054,120.50925695071176 30.62995499253387,120.51302927327897 30.648988074576557))’ ),
n.coord
)