between 开区间

引用\[1\]:between and 表示的是一个闭区间\[ \]的范围，如 price between 100 and 200 ，表示价格在 \[100,200\]这样一个范围。 select * from product where price between 2000 and 5000; // 查找价格在\[2000,5000\]范围内的产品 select * from product where price not between 2000 and 5000;// 查找价格不在\[2000,5000\]范围内的产品

问题: between开区间是什么意思?
回答: between开区间并不存在，between表示闭区间，即包括指定的两个边界值。\[1\]例如，price between 100 and 200 表示价格在\[100,200\]的范围内。如果要使用开区间，可以使用大于和小于符号来表示，例如price > 100 and price < 200。
#### 引用[.reference_title]
- *1* *2* [【MySQL-关键字】MySQL中区间查询 between and 和 in 用法和区别](https://blog.csdn.net/qq_44518192/article/details/122340807)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [MySQL知识总结](https://blog.csdn.net/weixin_50813961/article/details/126224020)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]