MyBatis中Like语句使用总结
2020-04-02 本文已影响0人
linson0116
// 原生
SELECT * FROM user WHERE name like '%${value}%'
// sqlserver
SELECT * FROM user WHERE name like '%'+#{name}+'%'
// mysql
SELECT * FROM user WHERE name like CONCAT('%',#{name},'%')
