MySQL--Select条件判断、in、not in、and、or、以及like匹配字符语句查询

      更多关于数据库知识请加关注哟~~。若需联系和想安装MySQL请加博主:
      QQ:3327908431
      微信：ZDSL1542334210

        前言：select语句通俗易懂，但是每当它遇到冤家—条件判断、and、or、条件匹配的时候，就稍微绕点了，此处阁下是如何做的？不妨远程观战博主如何？

1、创建用于查询的表格

(1)学生信息表stu

create table stu (s_id varchar(3), s_name varchar(4),
	s_sex varchar(1),s_age int,s_bothday varchar(11));
insert into  stu values
("001","李华","男",23,'1996-8-16'),
("002","王二","男",24,'1997-3-16'),
("003","赵敏","女",23,'1990-5-26'),
("004","张莹莹","女",22,'1995-2-16'),
("005"