where用法
#####查询where后面条件的数据
SELECT * from runoob_tbl WHERE runoob_author='菜鸟教程';
SELECT * from runoob_tbl WHERE runoob_author>1 AND runoob_author<=8;
//下面也是两个之间
select * from scores where score between 2500 and 3000;
模糊查询like用法
用like关键字查询
//%代表n个元素,_ 代表的是一个元素
SELECT * from user WHERE user_name like ‘%李%’;
//查询所有非姓李 元素
SELECT * from user WHERE user_name not like ‘李%’;
查询null用法
null表示为空
//查询所有元素为空的
SELECT * from user WHERE user_bir is null;
//查询所有非空元素
SELECT * from user WHERE user_bir is not null;
对查询结果排序
用
//查询所有元素为空的
SELECT * from user WHERE user_bir is null;
//查询所有非空元素
SELECT * from user WHERE user_bir is not null;