ST_GeomFromMySQL

Introduction: Construct a Geometry from MySQL Geometry binary.

Format: ST_GeomFromMySQL (binary: Binary)

Return type: Geometry

Since: v1.8.0

SQL Example

SELECT
    ST_GeomFromMySQL(geomWKB) AS geom,
    ST_SRID(ST_GeomFromMySQL(geomWKB)) AS srid
FROM mysql_table

Output:

+-------------+----+
|         geom|srid|
+-------------+----+
|POINT (20 10)|4326|
|POINT (40 30)|4326|
|POINT (60 50)|4326|
+-------------+----+