Mybatis模糊查询并且忽略大小写select * from tableA a where upper(a.A) like concat(concat(‘%’,upper(#{a.B})),’%’)版权声明：本文为Leon_summer原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。原文链接：https://blog.csdn.net/Leon_summer/article/details/89948761