sql like 多条件

select * from student where name like 'mike%' or name like 'rose%';