%匹配任意字符
_匹配单个字符
\转义字符
查询要求
查找以A开头的名字
SQL代码
SELECT FirstName FROM CUSTOMER
WHERE FirstName LIKE "A%";
查询结果
总结
查询名字中包含A的
SELECT FirstName
FROM CUSTOMER
WHERE FirstName LIKE "%A%";
查询以A结尾的名字
SELECT FirstName FROM CUSTOMER
WHERE FirstName LIKE "%A"
查询第二个字母是a的名字
SELECT FirstName FROM CUSTOMER
WHERE FirstName LIKE "_A%";