convert geojson to mysql_shape column type

[dacresni]

then use st_centroid to calculate centre after

[daniellovett]

Working on this. Here's my SQL:

UPDATE parcels_geojson
SET temp1 = coordinates;

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, '], [', '||');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, '[[[[', 'MULTIPOLYGON(((');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, ']]]]', ')))');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, ', ', ' ');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, '||', ',');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, '[[', '((');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, ']]', '))');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, '],[', '),(');

UPDATE parcels_geojson
SET temp1 = REPLACE(temp1, '[]', NULL)
WHERE temp1 = '[]';

// needed to add first point again at the end
UPDATE parcels_geojson
SET temp2 = CONCAT(SUBSTRING(temp1, 16, 36),')))');

UPDATE parcels_geojson
SET temp1 = REPLACE(')))', temp2);

UPDATE parcels_geojson
SET multi_poly = ST_GeomFromText(temp1);