create_geometry.sql

ALTER TABLE ip_ranges add ip_range POLYGON NULL;
UPDATE ip_ranges
  SET ip_range=Polygon(
    LineString(
      Point(ip_start, 1),
      Point(ip_start, 0),
      Point(ip_end, 0),
      Point(ip_end, 1),
      Point(ip_start, 1)
    )
  );

ALTER TABLE ip_ranges MODIFY ip_range POLYGON NOT NULL;
CREATE SPATIAL INDEX index_ip_ranges_on_ip_range on ip_ranges (ip_range);

range.sql

SELECT * FROM ip_ranges
  WHERE ip_start <= @new_ip_end AND
        @new_ip_start <= ip_end;

range_spatial.sql

SELECT * FROM ip_ranges
  WHERE Intersects(ip_range,
    Polygon(
      LineString(
        Point(@new_ip_start, 1),
        Point(@new_ip_start, 0),
        Point(@new_ip_end, 0),
        Point(@new_ip_end, 1),
        Point(@new_ip_start, 1)
      )
    )
  );

Hi,

Thank you for your great tutorial, it really helped me to optimize the queries.
https://www.bignerdranch.com/blog/using-mysql-spatial-extensions-for-range-queries/

I was wondering if we could store the version of the IP (4,6) as a Point in the LineString? Is that possible?

Thank you.