Mysql中的between和and
mysql范围查询时可以用 <= 和 >= ,也可以用between...and...
查询结果:相同

sql:select * FROM tb_user where age <= 28 and age >= 25;

sql:select * FROM tb_user where age between 25 and 28;

执行计划:相同
sql:explain select * FROM tb_user where age <= 28 and age >= 25;

sql:explain select * FROM tb_user where age between 25 and 28;


浙公网安备 33010602011771号