三、LIKE和通配符

SELECT *
FROM student 
WHERE SNAME LIKE '王%'

SELECT *
FROM student 
WHERE SNAME not LIKE '王%'

SELECT *
FROM student 
WHERE SNAME not LIKE '%小%' #名字不叫X小X

SELECT *
FROM student 
WHERE SNAME LIKE '王_'  #王芳、王丽被筛选出来，王小川不会

SELECT * FROM Persons
WHERE City LIKE '[ALN]%' #从 "Persons" 表中选取居住的城市以 "A" 或 "L" 或 "N" 开头的人

SELECT * FROM Persons
WHERE City LIKE '[!ALN]%'  #从 "Persons" 表中选取居住的城市不以 "A" 或 "L" 或 "N" 开头的人