MyBatis中Like语句使用总结

转载于点击打开链接

oracle数据库：

1. SELECT
2. *
3. FROM
4. user
5. WHERE
6. name like CONCAT('%',#{name},'%')

或 :

1. SELECT
2. *
3. FROM
4. user
5. WHERE
6. name like '%'||#{name}|| '%'

SQLServer数据库： 

1. SELECT
2. *
3. FROM
4. user
5. WHERE
6. name like '%'+#{name}+ '%'

mysql数据库： 

1. SELECT
2. *
3. FROM
4. user
5. WHERE
6. name like CONCAT('%',#{name},'%')

DB2数据库：

1. SELECT
2. *
3. FROM
4. user
5. WHERE
6. name like CONCAT('%',#{name},'%')

或 

1. SELECT
2. *
3. FROM
4. user
5. WHERE
6. name like '%'||#{name}|| '%'

使用mybatis标签:

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