: why this query doesn't use index?
Hello,
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;
++-+---+--+---+--+-+---
---+---+-+
| id
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 * FROM
Hello,
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;
++-+---+--+---+--+-+--+---+-+
| id | select_type | table | type | possible_keys |