MySQL学习5:查询拓展与排序

select name from students where name like "小%";

select name from students where name like "__";

select name from students where name like "__%";

 select name from students where name rlike "^章.*";

select name from students where age in (18,34);
--等价于
select name from students where age=18 or age=34;

select name from students where age between 18 and 34;

select name from students where height is NULL;

select * from students order by age asc;

select * from students order by age asc, height asc;

select * from students order by age desc;