select * from student where name like ‘mike%‘ or name like ‘rose%‘;
sql like 多条件
原文:http://www.cnblogs.com/lwmp/p/7233680.html