hi how can i use more than one 'between' clause in mysql query ? like if i want to select students having height between 20 and 25 and weight between 50 and 70..
thanks in advance
tismon
maybe you should use the and operator
Eineki
2010-03-29 11:43:36
Should be `... AND weight BETWEEN 50 AND 70`
Péter Török
2010-03-29 11:44:18
No it shouldn't. How can a value be between 20 and 25, and 50 and 70 at the same time? If my height is 23, it can't be 62 at the same time.
reko_t
2010-03-29 11:48:49
...HEIGHT between 20 and 25 and WEIGHT between 50 and 70..
tismon
2010-03-29 11:56:08
Oops, I misread the question. I thought he wanted height for both, but I see that he wanted weight for the second criteria now. Fixed the answer.
reko_t
2010-03-29 11:56:27
A:
WHERE height BETWEEN 20 AND 25 AND weight BETWEEN 50 AND 70
Bear in mind that your condition being applied to each row one-by-one, not to "whole table at once".
Col. Shrapnel
2010-03-29 11:57:07