MySQL中帶in關鍵字的集合查詢

帶in關頭字的調集查詢

方式/步調

1
只查詢ID為2,4,6的信息
select username from user where id in (2,4,6);
2
除了不查詢ID為2,4,6的信息外，其他的信息
select username from user where not id in (2,4,6);
3
查詢sex中開首為w的信息
select username,age from user where sex like 'w%';
4
查詢address中中心有u的信息,'_'的利用
select username,age from user where address like '_u%';
查詢address中含有a的信息
select username,age from user where address like '%a%';
5
按春秋排序
select*from user order by age asc;(升序)
select*from user order by age desc;(j降序)
6
limit的利用
限制查詢前5個信息