like模糊查询,语法:where 字段 like '%包含值%'如查询学生表student中姓名name包含诸葛的:select * from student s where s.name like '%诸葛%'