> 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 usin
see
http://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
> 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
