mybatis 模糊查询（like和match against两种）

 <select id="searchUser" parameterType="java.lang.String" resultType="com.datebook.vo.UserDetailVO">
   select id,mobile,header,nickname,gender,birthday,signature,photoes,book_cnt 
    from user where <!-- nickname like CONCAT('%',#{key},'%')
       or mobile like CONCAT('%',#{key},'%')  -->
        MATCH (nickname,mobile) AGAINST (#{key} IN NATURAL LANGUAGE MODE) 
 </select>