MyBatis中Like语句使用总结

// 原生
SELECT *  FROM  user WHERE  name like '%${value}%'
// sqlserver
SELECT *  FROM  user WHERE  name like '%'+#{name}+'%' 
// mysql
SELECT *  FROM  user WHERE  name like CONCAT('%',#{name},'%')