select * from student where name like 'mike%' or name like 'rose%'; 转载于:https://www.cnblogs.com/lwmp/p/7233680.html