模糊查询 运算符语法描述is nulla is null如果操作符为null,结果为真is not nulla is not null如果操作符不为null,结果未真betweena between b and c若a在b和c之间,结果为真likea like bSQL匹配,如果a匹配b,则结果为真ina in (a1,a2,a3…)假设a在a1,或者a2…其中的某一个值中,结果为真 like 例子:(%代表0到任意字符,_表示一个字符) 查询姓刘的同学:select studentNo,studentName from student where studentName like ‘刘%’