mybits中IN和LIKE查询

<select useCache="false" id="getConcernPageByUserEname" resultType="com.zbxsoft.chtrans.entity.ChConcern" parameterType="java.util.Map">
SELECT * FROM
(select co.*,rownum as row_num from (
SELECT * FROM CH_CONCERN h where 1=1
<if test="usercname !=null and usercname != ''">
AND h.USERCNAME like concat(concat('%', #{usercname}),'%')
</if>
<if test="userenames !=null and userenames != ''">
AND h.USERENAME in
<foreach item="item" index="index" collection="userenames"
open="(" separator="," close=")">
#{item}
</foreach>
</if>
<if test="userenames == ''">
AND 1=-1
</if>
order by h.creattime desc ) co) tt
WHERE tt.row_num BETWEEN #{offset} AND #{limit}

</select>