MySQL中带in关键字的集合查询

1、只查询ID为2,4,6的信息select username from user where id in (2,4,6);

3、查询sex中开头为w的信息select username,age from user where sex like 'w%';