--- Original Message -
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, February 03, 2001 3:53 AM
>Subject: BETWEEN problem?
>
>
> > Can anyone explain the following results to me?
> >
> > I am trying to find all values +/- 30%
lt;[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 3:53 AM
Subject: BETWEEN problem?
> Can anyone explain the following results to me?
>
> I am trying to find all values +/- 30% from a number...
> value is declared as: | value | int(10) unsigned
> Note that 1.3*63000 is 81900.
Maybe you should try
SELECT count(*) FROM bench WHERE year = 95 and
-> value BETWEEN (0.7*63000) and (1.3*63000) ;
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 03, 2001 3:53 AM
Subject: BETWEEN problem?
> Can
Can anyone explain the following results to me?
I am trying to find all values +/- 30% from a number...
value is declared as: | value | int(10) unsigned
Note that 1.3*63000 is 81900...
The first two are apparently correct:
mysql> SELECT count(*) FROM bench WHERE year = 95 and
-> value >=