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](https://geek.csdn.net/educolumn/184b56c51fd333211e6f2a08e35b0efe?spm=1055.2569.3001.10083)-关键字】[mysql](https://geek.csdn.net/educolumn/184b56c51fd333211e6f2a08e35b0efe?spm=1055.2569.3001.10083)中区间查询 between and 和 in 用法和区别](https://blog.csdn.net/qq_44518192/article/details/122340807)[tar[get](https://geek.csdn.net/educolumn/31aebce56f4ecc5451aac3a194ff6259?spm=1055.2569.3001.10083)="_b[lan](https://geek.csdn.net/educolumn/2e627c1ce792f2bd6c896ec0221f0ac0?spm=1055.2569.3001.10083)k" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chat[gpt](https://geek.csdn.net/educolumn/d2f82220638caf1d7a0d5521eb7b6775?dp_token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NDQ0MDg2MiwiZXhwIjoxNzA5NTQ4NzEwLCJpYXQiOjE3MDg5NDM5MTAsInVzZXJuYW1lIjoid2VpeGluXzY4NjQ1NjQ1In0.Ycp4bmJnbuf-GXluSQA922QiehPy9qQiboAgoDqZFno&spm=1055.2569.3001.10083)_common_search_p