1. 使用WHERE子句
过滤数据
SELECT prod_name, prod_price
FROM products
WHERE prod_price = 2.5;
2. WHERE子句操作符
= | 等于 |
<> | 不等于 |
!= | 不等于 |
< | |
<= | |
> | |
>= | |
BETWEEN A AND B | [A, B] |
3. 字符串相等
SELECT prod_name, prod_price
FROM products
WHERE prod_name = 'fuses';
字符串字面值加''单引号
4. 空值检查
NULL不是不匹配,而是具有NULL值的行
SELECT cust_id
FROM customers
WHERE cust_email IS NULL;