// 原生
SELECT * FROM user WHERE name like '%${value}%'
// sqlserver
SELECT * FROM user WHERE name like '%'+#{name}+'%'
// mysql
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
// 原生
SELECT * FROM user WHERE name like '%${value}%'
// sqlserver
SELECT * FROM user WHERE name like '%'+#{name}+'%'
// mysql
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
本文标题：MyBatis中Like语句使用总结
本文链接：https://www.haomeiwen.com/subject/fgxxphtx.html
网友评论