mysql的大于小于
时间: 2023-10-19 17:32:18 浏览: 52
MySQL中的大于小于操作符和其他语言的使用方法类似。以下是对照表,摘自《MySQL必知必会》:
- = 等于
- != 不等于
- > 大于
- >= 大于等于
- < 小于
- <= 小于等于
- BETWEEN 在指定的值之间
- <> 不等于
在执行匹配时,默认情况下MySQL不区分大小写。例如,如果我们有一张名为book的表,其中最后一条数据的book_name为HTML(大写),我们可以执行以下语句进行匹配:
SELECT book_name, author FROM book WHERE book_name = 'html';<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [MySQL 基操教程(五) SELECT 数据查看之大于、小于](https://blog.csdn.net/weixin_43354181/article/details/88091989)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [常用mysql数据库配置文件](https://download.csdn.net/download/zslsh44/88278582)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]