<select id="fuzzySearchUserid" parameterType="String"
resultType="com.joshvm.commons.bean.mysql.User">
SELECT
*
FROM
user
<where>
<if test="username!=null">
username LIKE '%${username}%'
</if>
<if test="nickname!=null">
AND nickname LIKE '%${nickname}%'
</if>
<if test="email!=null">
AND email LIKE '%${email}%'
</if>
<if test="state!=null">
AND state = ${state}
</if>
<if test="createTimeBetween!=null">
AND UNIX_TIMESTAMP(create_time) >= ${createTimeBetween}
</if>
<if test="createTimeTo!=null">
AND UNIX_TIMESTAMP(create_time) <= ${createTimeTo}
</if>
</where>
</select>