`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 ^ U contains (ST ^ U Polygon ("Polygon ((0, 10, 10, 10, 10, 10, 0, 10, 0, 0, 0))), ST ^ UPOint (5, 5));
  2. +----------------------------------------------------------------------------------------+
  3. + 124; ST = U Contains (ST = U Polygon ((0, 10, 10, 10, 0, 10, 0))), ST = UPoint (5.0, 5.0)) 124';
  4. +----------------------------------------------------------------------------------------+
  5. |                                                                                      1 |
  6. +----------------------------------------------------------------------------------------+
  8. MYSQL > Select St ^ U contains (ST ^ U Polygon ("Polygon ((0, 10, 10, 10, 10, 10, 0, 10, 0, 0, 0))), St ^ UPOINT (50, 50));
  9. +------------------------------------------------------------------------------------------+
  10. + 124; ST = U Contains (ST = U Polygon ((0, 10, 10, 10, 0, 10, 0))), ST = UPoint (50.0, 50.0)) 124
  11. +------------------------------------------------------------------------------------------+
  12. |                                                                                        0 |
  13. +------------------------------------------------------------------------------------------+

keyword ST_CONTAINS,ST,CONTAINS