How can I use more than one 'between' clause in a MySQL query? For example if I want to select students having height between 20 and 25 and weight betwe开发者_开发技巧en 50 and 70.
WHERE height BETWEEN 20 AND 25 AND weight BETWEEN 50 AND 70
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".
精彩评论