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
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 to be
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 to