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;

 

posted @ 2025-07-18 17:42  请别耽误我写BUG  阅读(13)  评论(0)    收藏  举报