ST_GeometryN(gc, N)

Returns the N-th geometry in the GeometryCollection value gc.
Geometries are numbered beginning with 1. If any argument is NULL or
the geometry argument is an empty geometry, the return value is NULL.

URL: https://dev.mysql.com/doc/refman/5.7/en/gis-geometrycollection-property-functions.html

