Re: BETWEEN problem?

2001-02-04 Thread Bob Hall
--- 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%

Re: BETWEEN problem?

2001-02-03 Thread fred
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.

Re: BETWEEN problem?

2001-02-03 Thread Rus
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

BETWEEN problem?

2001-02-02 Thread fred
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 >=