Mybatis中模糊查询like语句的使用方法

public void getUserByName(String name) {
   userDao.getUserByName("%" + name + "%");
 }

<select id="getUserByName" parameterType="string" resultType="cn.truedei.entity.User">
    SELECT    *    FROM user   WHERE   name  LIKE  #{name}
  </select>

<select id="getUserByName" parameterType="string" resultType="cn.truedei.entity.User">
    SELECT * FROM user WHERE name  like CONCAT('%',#{name},'%')  
  </select>

<select id="getUserByName" parameterType="string" resultType="cn.truedei.entity.User">
    SELECT * FROM user WHERE name  like "%"#{name}"%"  
  </select>