`ST_Contains’

Description

Syntax

BOOL ST_Contains(GEOMETRY shape1, GEOMETRY shape2)

Judging whether geometric shape 1 can contain geometric shape 2 completely

example

1. mysql> SELECT ST_Contains(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_Point(5, 5));
2. +----------------------------------------------------------------------------------------+
3. | st_contains(st_polygon('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))'), st_point(5.0, 5.0)) |
4. +----------------------------------------------------------------------------------------+
5. |                                                                                      1 |
6. +----------------------------------------------------------------------------------------+

8. mysql> SELECT ST_Contains(ST_Polygon("POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))"), ST_Point(50, 50));
9. +------------------------------------------------------------------------------------------+
10. | st_contains(st_polygon('POLYGON ((0 0, 10 0, 10 10, 0 10, 0 0))'), st_point(50.0, 50.0)) |
11. +------------------------------------------------------------------------------------------+
12. |                                                                                        0 |
13. +------------------------------------------------------------------------------------------+

keyword

ST_CONTAINS,ST,CONTAINS w