模糊查询

发布时间 2023-04-22 15:50:51作者: wzh_Official

select * from tb_user where username like "%"#{username}"%";
===>
select * from tb_user where username like "%a%";
===>
user{id=1, username='zhangsan', password='123', gender='男', addr='北京'}
user{id=5, username='Jack', password='123J', gender='男', addr='阿美利卡'}

image
image
image