逻辑匹配
多个判断条件时使用
or 或
and 与
!或 not 非
( ) 提高优先级
mysql> select name,uid,shell from user
-> where
-> name="root" and uid=1 and shell="/bin/bash";
Empty set (0.00 sec)
mysql> select name,uid,shell from user where name="root" or uid=1 or shell="/bin/bash";
+------+------+---------------+
| name | uid | shell |
+------+------+---------------+
| root | 0 | /bin/bash |
| bin | 1 | /sbin/nologin |
| lisi | 1000 | /bin/bash |
| bob | 3001 | /bin/bash |
+------+------+---------------+
mysql> select name from user where name="root";
+------+
| name |
+------+
| root |
+------+
mysql> select name from user where name is null;
Empty set (0.00 sec)
mysql> select name from user where name is not null;
+---------------------+
| name |
+---------------------+
| root |
... ...