模糊查询关键字：like'%'-表示0/多个字符eg：select * from stu where name like 'java%';(查询以java开头的信息)select * from stu where name like '%java%';(查询包含java的信息)select * from stu where name like '%java';(查询以java结尾的信息)'_'-匹配单个任意字符eg：select * from user where name like '张_';(姓...