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%';
MySQL中带in关键字的集合查询
时间：2024-10-13 23:20:331、只查询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%';