Locate_Between
LOCATE_BETWEEN(Geometry g, float f1, float f2, float f3);
Alias: ST_LOCATE_BETWEEN
Returns a point collection containing all points of g that have an M ordinate between f1 and f2. If f3 is non-zero, the resulting points are offset by the specified value.
The first argument g must be of type PointM, PointZM, LinestringM, LinestringZM, MultiLinestringM, MultiLinestringZM, MultiPointM, or MultiPointZM.
The second and third arguments, f1 and f2, make up the measure (M) range that you want to locate geometries between.
The fourth argument f3 is the offset you want to adjust the result geometries by.
Result type: A geometry collection of appropriate type.
Example:
SELECT ASTEXT(LOCATE_BETWEEN(GEOMFROMTEXT('MULTILINESTRING M ((1 2 3, 3 4 2, 9 4 3), (1 2 3, 5 4 5))'), 1.5, 3, 0));
-------------
col1
-------------
GEOMETRYCOLLECTION M(LINESTRING M(1 2 3, 3 4 2, 9 4 3), POINT M(1 2 3))
-------------