SQL模糊查找LIKE 通配符%

%匹配任意字符 _匹配单个字符 \转义字符

查询要求

查找以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%";