逻辑运算符列表：

实例：

　　还是用之前的表：
　　那么，请看：

sqlite> select * from student where AGE is null;
sqlite> select * from student where AGE =18 and AGE =19;
sqlite> select * from student where AGE =18 or AGE =19;
ID     NAME        AGE
-----  ----------  ----------
1      xiaoming    18
2      xiaohua     18
3      mingming    19
sqlite> select * from student where AGE =18 and ID =1;
ID     NAME        AGE
-----  ----------  ----------
1      xiaoming    18
sqlite> select * from student where NAME like 'm%';
ID     NAME        AGE
-----  ----------  ----------
3      mingming    19
sqlite> select  * from student where AGE IN(19,20);
ID     NAME        AGE
-----  ----------  ----------
3      mingming    19
4      xiaogang    20
sqlite> select * from student where AGE not IN(19,20);
ID     NAME        AGE
-----  ----------  ----------
1      xiaoming    18
2      xiaohua     18
sqlite> select * from student where NAME glob 'm\*';
ID     NAME        AGE
-----  ----------  ----------
3      mingming    19
sqlite>