MyBatis like (模糊查询)

 

select * from user where user_name like concat('%',#{userName},'%');

select * from user where user_name like concat(#{userName},'%');

select * from user where user_name like concat('%',#{userName});

 

 

点滴笔记(LC)