Split comma separated values into separate mySQL f

2019-09-12 04:41发布

问题:

I am using plugin that geocodes from an address string. The problem is that it returns the lat/long as comma separated value in a single field.

What I need to do is find a way to take that, split the values and then save them into the geo_latitude, geo_longitude fields.

Is there a plug in or function that could achieve this?