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
://www.upscene.com/displaynews.php?item=20120713
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
trade_time IN ('2012-07-01', '2012-07-02');
represents two distinct points in a continuum of a DATETIME. Perhaps you
should change to DATE. Even then, it would probably be treated as IN, not
RANGE. Perhaps you really want BETWEEN (a range) instead of IN (a set).
What version are you using?