ST_Within()

Returns 1 when the first geometry is completely within the second geometry.

Syntax

ST_Within(geom1, geom2)

Aliases: none.

Arguments

geom1 and geom2 are GEOMETRY values.

Return Value

Returns BOOL.

Usage Notes

  • ST_Within(a, b) is the inverse positional relationship of ST_Contains(b, a).

  • Both geometries must have the same SRID. The relationship is evaluated using planar coordinate semantics; matching SRID 4326 inputs are accepted, but this does not provide geodetic predicate semantics.

Examples

DROP DATABASE IF EXISTS geo_within_demo;
CREATE DATABASE geo_within_demo;
USE geo_within_demo;

SELECT ST_Within(ST_GeomFromText('POINT(2 2)'), ST_GeomFromText('POLYGON((0 0, 4 0, 4 4, 0 4, 0 0))')) AS within_polygon;

DROP DATABASE geo_within_demo;

See Also

ST_Contains(), ST_CoveredBy().