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%';
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%';