mybatis-plus 中用or多条件动态拼接查询

数据表保存的字段数据如下：

前端GET方式提交，传字符串数组过来，

后端java代码如下：

if(StringUtils.isNotNull(bo.getRoomDevice()) && !bo.getRoomDevice().isEmpty()){
    Consumer<LambdaQueryWrapper<MeetingRoom>> consumer = (r) -> {};
    for (String roomDevice : bo.getRoomDevice()) {
        Consumer<LambdaQueryWrapper<MeetingRoom>> deviceConsumer = (r) -> {
            r.apply("JSON_CONTAINS(room_device, CONCAT('\"', {0}, '\"'))", roomDevice);
        };
        consumer = consumer.andThen(r -> r.or(deviceConsumer).or());
    }
    lqw.and(consumer);
}