ST_CONTAINS
Checks whether one geometry contains another. Returns 1 if true.
Analyze Syntax
func.st_contains(<geometry1>, <geometry2>)
Analyze Examples
func.st_contains(get_column(table, 'area'), func.st_point(1, 1))
┌───┐
│ 1 │
└───┘
SQL Syntax
ST_CONTAINS(<geometry1>, <geometry2>)
SQL Examples
SELECT ST_CONTAINS(ST_GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0))'), ST_POINT(5, 5));
┌───┐
│ 1 │
└───┘