ST_GeometryType(g)

Returns a binary string indicating the name of the geometry type of
which the geometry instance g is a member, or NULL if the argument is
NULL. The name corresponds to one of the instantiable Geometry
subclasses.

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

