SQL语句之DQL--条件查询

-- 条件查询 =================

SELECT * from stu WHERE age > 20;


SELECT * from stu WHERE age >= 20;

SELECT * from stu WHERE age >= 20 && age <= 30;    -- 不建议使用

SELECT * from stu WHERE age >= 20 AND age <= 30;    

SELECT * FROM stu where age BETWEEN 20 AND 30;-- 范围内使用

select * from stu WHERE hire_date BETWEEN '1695-09-02' AND '1994-09-04';

-- SELECT * FROM stu where age == 18;-- sql里面没有==，比较直接=

select * FROM stu WHERE age = 18;

select * FROM stu WHERE age != 20;
SELECT * from stu where age <> 20;

SELECT * from stu WHERE age=18 OR age=20 OR age=22; 有||，但不推荐

SELECT * from stu where age IN(18,20,22);-- 多选一使用

-- SELECT * from stu where english = null;
-- NULL值的比较不能使用= !=之类的,要使用is is NOT

SELECT *from stu where english is null;

SELECT *from stu where english is not null;

模糊查询

-- LIKE
SELECT * from stu where `NAME` LIKE '马%';

SELECT * from stu where name like '马_';

SELECT * from stu where name like '_花%';

SELECT * from stu where `NAME` LIKE '%德%';

-- 下划线_匹配单个字符  %匹配任意个数字符