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...
>
, 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
--- ---
To: MySQL list
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
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 field
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
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 me
