mysql条件查询语句

–MySQL条件查询语句：

–比较运算符
–select …from 表名 where …
– > 查询大于18岁的信息

-- < 查询小于18岁

-- <= /  >=  / !=  / =

– 逻辑运算符

--and 逻辑与
-- select * from students where age>18 and age <28;

--or 逻辑或 select * from students where age<18 or age >28;

--not 逻辑非 select * from students where not age<18 ;

–模糊查询
–like
–%替换1个或者多个
–_替换1个
–查询姓名中 以“小”开头的名字select name from students where name like “小%”;
–查询姓名中 有“小”开头的名字select name from students where name like “%小%”;

--查询有2个字的名字
select name from students where name like "__";


--查询有2个字以及2个字以上的名字
select name from students where name like "__%";

--rlike
select name from students where name rlike "^周.*"; 以周开头的

–范围查询
–in
select name ,age from students where age in(18,12,34); 非连续

--not in
select name ,age from students