sql多條件模糊搜索

 SELECT
          um.title,um.content,um.cover,um.create_time as createTime,ue.`collected_id` as collectedId,u.nickname, u.head,um.comments,um.thumb_number as thumbNumber,um.browse_number  as browseNumber
          FROM user_enshrine  ue
          LEFT JOIN user_media um ON ue.`article_id` =um.`id` AND um.enable=1 AND  um.user_id=ue.`collected_id`
          LEFT JOIN USER u ON ue.collected_id=u.id
          WHERE   ue.user_id=#{userId}  AND ue.enable=1
          <if test="keyword != null">
            and (u.nickname  LIKE '%${keyword}%' or um.title LIKE  '%${keyword}%' OR um.content LIKE  '%${keyword}%')
          </if>
          <if test="pageSize != null and page != null">
            LIMIT #{page},#{pageSize}
          </if>

and (u.nickname LIKE ‘%${keyword}$keyword{keyword}%’ OR um.content LIKE ‘%${keyword}%’)