开发者

More than one between clause

开发者 https://www.devze.com 2022-12-24 06:28 出处:网络
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 BETWE

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

精彩评论

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