select * from mybatis.people where name like CONCAT('%',#{name},'%');
like
%表示多个字符
_表示一个字符,两个_则表示两个字符
例:
“柳”字后面单字符查询
SELECT `id`,`name` FROM `student`
WHERE `name` LIKE '柳_'
“柳”字后面多字符查询
SELECT `id`,`name` FROM `student`
WHERE `name` LIKE '柳%'
in
in()--里面只能填表中具体对应的数值
例:
查询id为1和3的名字
SELECT `id`,`name` FROM student
WHERE `id` IN(1,3)