Java神鬼莫测之MyBatis--各类数据库like字段使用方式(一)

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

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

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

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