MyBatis中Like语句使用总结

Oracle数据库：

SELECT  *  FROM  user  WHERE  name like CONCAT('%',#{name},'%')  

或 :

SELECT  *  FROM  user  WHERE  name like '%'||#{name}||'%'  

SQLServer数据库：

SELECT  *  FROM  user  WHERE  name like '%'+#{name}+'%'  

mysql数据库：

SELECT  *  FROM  user  WHERE  name like CONCAT('%',#{name},'%')  

DB2数据库：

SELECT  *  FROM  user  WHERE  name like CONCAT('%',#{name},'%')  

或

SELECT  *  FROM  user  WHERE  name like '%'||#{name}||'%'  

使用mybatis标签:

<select id="selectPersons" resultType="person" parameterType="person">    <bind name="pattern" value="'%' + _parameter.username + '%'" />    select id,sex,age,username,password     from person    where username LIKE #{pattern}  </select>