mybatis

mysql  模糊查询:

and name like concat('%',#{name},'%')

sqlserver:模糊查询:

and name like '%'+#{name}+'%'