MySQL comparison operator problem

Hi,
I've got a bit of a baffling problem with MySQLs comparison operators.

I am trying to select pumps with a flow rate (flow_0) of between 3000 and 6001 using the following statement.

SELECT model,flow_0 FROM pumps WHERE flow_0 >='3000' AND flow_0 <='6001' ORDER BY five_year_cost ASC LIMIT 0, 30

The query returns three pumps, two with a flow_0 between 3000 and 6000, but also one of flow_0 500.

model flow_0
SH 500 500

SH 3500 3690

SH 5500 5520

I have also tried using BETWEEN, but this returns the same data...

Any one got any idea what I am doing wrong?
Many thanks,

Matt

thats because you are comparing flow_0 like a non-numeric variable,in which case '500' is > '3001'.
remove the quote ' ' around the values

try this
SELECT model,flow_0 FROM pumps WHERE flow_0 >=3000 AND flow_0 <=6001 ORDER BY five_year_cost ASC LIMIT 0, 30

reg
kevin

Hi Kevin,
Thanks for the incredibly speedy response! I've just tried your solution and it works brilliantly!

Thanks alot!
Matt