DQL 查询表中的数据二

条件查询

	1. where子句后跟条件
	2. 运算符
		* > 、< 、<= 、>= 、= 、<>
		* BETWEEN...AND  
		* IN( 集合) 
		* LIKE：模糊查询
			* 占位符：
				* _:单个任意字符
				* %：多个任意字符
		* IS NULL  
		* and  或 &&
		* or  或 || 
		* not  或 !
		
			-- 查询年龄大于20岁

			SELECT * FROM student WHERE age > 20;
			
			SELECT * FROM student WHERE age >= 20;
			
			-- 查询年龄等于20岁
			SELECT * FROM student WHERE age = 20;
			
			-- 查询年龄不等于20岁
			SELECT * FROM student WHERE age != 20;
			SELECT * FROM student WHERE age <> 20;
			
			-- 查询年龄大于等于20 小于等于30
			
			SELECT * FROM student WHERE age >= 20 &&  age <=30;
			SELECT * FROM student WHERE age >= 20 AND  age <=30;
			SELECT * FROM student WHERE age BETWEEN 20 AND 30;
			
			-- 查询年龄22岁，18岁，25岁的信息
			SELECT * FROM student WHERE age = 22 OR age = 18 OR age = 25
			SELECT * FROM student WHERE age IN (22,18,25);
			
			-- 查询英语成绩为null
			SELECT * FROM student WHERE english = NULL; -- 不对的。null值不能使用 = （!=） 判断
			
			SELECT * FROM student WHERE english IS NULL;
			
			-- 查询英语成绩不为null
			SELECT * FROM student WHERE english  IS NOT NULL;
			-- 查询姓马的有哪些？ like
			SELECT * FROM student WHERE NAME LIKE '马%';
			-- 查询姓名第二个字是化的人
			
			SELECT * FROM student WHERE NAME LIKE "_化%";
			
			-- 查询姓名是3个字的人
			SELECT * FROM student WHERE NAME LIKE '___';
			-- 查询姓名中包含德的人
			SELECT * FROM student WHERE NAME LIKE '%德%';

-- 大于20 小于30
SELECT * FROM student3 WHERE age >= 20 && age <= 30;
SELECT * FROM student3 WHERE age >= 20 AND age <= 30;
SELECT * FROM student3 WHERE age BETWEEN 20 AND 30;

-- 查询 22 18 25
SELECT * FROM student3 WHERE age = 22 OR age = 18 OR age = 25;
SELECT * FROM student3 WHERE age IN(22,18,25);

-- 查询英语成绩为null
SELECT * FROM student3 WHERE english IS NULL;
-- 查询英语成绩不为null
SELECT * FROM student3 WHERE english IS NOT NULL;

-- 查询姓马的 LIKE
SELECT * FROM student3 WHERE `name` LIKE '马%';
-- 第二马字
SELECT * FROM student3 WHERE `name` LIKE '_化%';
-- 查询名字是三个字的
SELECT * FROM student3 WHERE `name` LIKE '___';
-- 查询含有马字的人
SELECT * FROM student3 WHERE `name` LIKE '%马%';

SELECT * FROM student3 WHERE `name` LIKE '%德%';