1、使用AND操作符,增加WHERE子句条件
--------------------------------------------------------------
例:
SELECT a,b,c
FROM 表1
WHERE a=1 AND b!=5;
-------------------------------------------------------------------
2、OR 或 (用来表示检索匹配任一给定条件的行)
-----------------------------------------------------------------------
例:
SELECT a,b
FROM 表1
WHERE a='m' OR a='n';
---------------------------------------------------------------------
3、OR/AND 的优先级(AND优先级较高)
-----------------------------------------------------------------------
例:
SELET a,b
FROM 表1
WHERE (a='m' OR a='n')
AND b>=10;
------------------------------------------------------------------------