mysql between 语法

回答: MySQL的BETWEEN语法用于在SELECT、UPDATE、DELETE等适用WHERE表达式的SQL中筛选某个属性或表达式结果的某个范围内的数据。它的基本语法是：

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

其中，column_name是需要筛选的列名，table_name是需要查询的表名，value1和value2是范围的起始和结束值。BETWEEN关键字的作用是筛选出column_name列中值在value1和value2之间（包括value1和value2）的数据。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [MySQL BETWEEN 用法](https://blog.csdn.net/weixin_34050005/article/details/92009467)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* [mysql中between的用法](https://blog.csdn.net/zhangzehai2234/article/details/102756107)[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^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]