Videos / PlanetScaleSeptember 202313:4624.2k viewsFaster geospatial queries in MySQLWatch on YouTubeFiled under DatabasesChapters00:00A point of interest00:21Haversine formula01:00ST_DISTANCE_SPHERE distance calculation03:25Filtering by ST_DISTANCE_SPHERE04:28It's too slow05:11Bounding boxes06:55Using a bounding box08:10Adding an index10:20Adding a compound index11:34A note about POINT columns▶ PlayAboutSearching a table in MySQL based on latitude and longitude columns.