type
status
date
slug
summary
tags
category
icon
password
SELECT * FROM TableName WHERE DataName = ‘Name’;
SELECT * FROM TableName WHERE DataNameID = 1;
WHERE子句中的运算符
= | 等于 |
> | 大于 |
< | 小于 |
≥ | 大于等于 |
≤ | 小于等于 |
<> | 不等于 (!=) |
BETWEEN | 在一定范围之内 |
LIKE | 搜索模式 |
IN | 为一列指定多个可能的值 |
#BETWEEN 选择查询值的范围
SELECT * FROM TableName WHERE DataNameID BETWEEN 10 AND 20
#LIKE
SELECT * FROM TableName WHERE DataName LIKE ‘s%’;
#IN
SELECT * FROM TableName WHERE DataName IN (’Name1’,’Name2’);
- Author:KingCode
- URL:https://kingcode.dpdns.org/article/3a0b8231-7020-4613-97b7-15ddc57ed0a2
- Copyright:All articles in this blog, except for special statements, adopt BY-NC-SA agreement. Please indicate the source!
