模糊查询

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

posted @ 2023-04-22 15:43  wzh_Official  阅读(38)  评论(0)    收藏  举报