Things like that are hard to optimize. If you have no overlapping ranges, then
this will be much more efficient:
http://mysql.rjweb.org/doc.php/latlng
> -Original Message-
> From: Doug [mailto:d...@hacks.perl.sh]
> Sent: Thursday, July 12, 2012 7:03 PM
> To: mysql@lists.mysql.com
> Sub
> can you tell me why my this query doesn't use the index?
>
>
> mysql> explain select * from iploc where 1902800418 between start_ip
> and end_ip;
Hazarding a very quick guess: if this table is what I think it is (NON-
overlapping IP ranges + (geo)location), you might want to try:
SELECT * FR