Good morning James -
It looks like you have a multi-column index on the startIpNum and
endIpNum columns, but it's not doing you any good, at least not for
this query.
You don't mention how many rows of data you're searching against,
which would give a better idea as to what might be
Hello,
I am running Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (i386)
using readline 4.3 on a Dual Xeon 2.4Ghz RHEL4 box with 4GB of RAM.
I have a query that takes anywhere from .25 - .85 seconds to run.
Following are the query and the related table structures I have
currently set
From: Rob Brooks
Well, we have this db with various ip address ranges and the country of
origin associated with each ... the format is:
countryOfOrigin FromIP ToIP
--- --
US some lower bound some upper bound
Canada some lower bound some upper bound
Etc...
So the
Hello
Is there a way when searching for a range of values for a particular field
that mysql would not have to look at the entire table ... I'm guessing with
some type of composite key or something? ...
e.g.
SELECT aField FROM aDatabase WHERE aVariable BETWEEN field1 AND field2;
Field1 and
At 01:48 PM 3/25/2005, you wrote:
Hello
Is there a way when searching for a range of values for a particular field
that mysql would not have to look at the entire table ... I'm guessing with
some type of composite key or something? ...
e.g.
SELECT aField FROM aDatabase WHERE aVariable BETWEEN
Subject: Re: using between
At 01:48 PM 3/25/2005, you wrote:
Hello
Is there a way when searching for a range of values for a particular field
that mysql would not have to look at the entire table ... I'm guessing with
some type of composite key or something? ...
e.g.
SELECT aField FROM aDatabase WHERE
, 2005 1:05 PM
To: 'mos'; 'MySQL list'
Subject: RE: using between
Well, we have this db with various ip address ranges and the country of
origin associated with each ... the format is:
countryOfOrigin FromIP ToIP
--- --
US
On 13 Jan 2004 at 10:11, Eve Atley wrote:
I am attempting to construct a select statement in which I can find values
between two fields: start, and end. I have tried using BETWEEN and
comparing with = and =, but neither meet success. Can someone please set
me straight? This is meant
I am attempting to construct a select statement in which I can find values
between two fields: start, and end. I have tried using BETWEEN and
comparing with = and =, but neither meet success. Can someone please set
me straight? This is meant to be in a PHP page, but I'm assuming the syntax
From: Eve Atley [mailto:[EMAIL PROTECTED]
I am attempting to construct a select statement in which I
can find values between two fields: start, and end. I have
tried using BETWEEN and comparing with = and =, but
neither meet success. Can someone please set me straight?
This is meant
I have a table with one timestamp field named timedate (Unix_timestamp
format). I used the follow command but it's not working correctly:
mysql select count(*) from tablename where date_format(timedate,%Y-%m-%d)
between date_sub(now(), interval 1 DAY) and now();
Empty Set
This result is not
11 matches
Mail list logo