- version 5.7.5 or later of MySQL
ALTER TABLE flags ADD SPATIAL INDEX (coordinates)
GeomFromText('LINESTRING(LatSW LonSW, LatNE LonNE)')
GeomFromText('LINESTRING(42.6650 -71.0076,42.9549 -70.6124)')
ALTER TABLE flags ADD SPATIAL INDEX (coordinates)
GeomFromText('LINESTRING(LatSW LonSW, LatNE LonNE)')
GeomFromText('LINESTRING(42.6650 -71.0076,42.9549 -70.6124)')
http://www.plumislandmedia.net/mysql/haversine-mysql-nearest-loc/