开发者

More than one between clause

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".

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜