mysql存Long数组的查询

    /**
     * 被抽查的案件id（使用“,”分隔)
     */
    @TableField(value = "case_id",typeHandler = FastjsonTypeHandler.class)
    private Long[] caseId;

  <result column="case_id" property="caseId" typeHandler="com.baomidou.mybatisplus.extension.handlers.FastjsonTypeHandler"/>

json_contains查询数组中是否存在该值

SELECT
 *
FROM
t_file_share
WHERE
valid = 0 AND create_user_id=#{req.currentUserId}
<if test="req.recordId != null and req.recordId != ''">
    AND json_contains(folder_id,#{req.recordId})
</if>
<if test="req.name != null and req.name !=''">
    AND  create_user_name LIKE CONCAT('%', #{req.name},'%')
</if>
ORDER BY
create_time DESC