记这周学的几个SQL语句=u=,划水划水划水~
检索a在5和10之间的数据
select * from atable where a between 5 and 10;
检索当a值为空时的数据
select * from atable where a is null;
检索a、b为1,或者c为1时的数据
select * from atable where a=1 and b=1 or c=1;
检索a为1,或者b、c为1时的数据
select * from atable where a=1 or b=1 and c=1;
检索a、b为1,或者c为1时的数据
select * from atable where (a=1 or b=1) and c=1;
检索当a不在5到10区间时的数据
select * from atable where a not in (5,10);
检索a以head为开头、后面不计多少字符的数据
select * from atable where a like 'head%';
检索a以head为开头、后面只有一个字符的数据
select * from atable where a like 'head_';